2024-11-17 21:33:12.496 UTC postmaster[18675] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2024-11-17 21:33:12.496 UTC postmaster[18675] LOG: listening on Unix socket "/tmp/pg_regress-L6IGj4/.s.PGSQL.40009" 2024-11-17 21:33:12.498 UTC startup[18678] LOG: database system was shut down at 2024-11-17 21:33:12 UTC 2024-11-17 21:33:12.500 UTC postmaster[18675] LOG: database system is ready to accept connections 2024-11-17 21:33:13.271 UTC client backend[18779] pg_regress/not_equal ERROR: conflicting key value violates exclusion constraint "zoo_cage_animal_excl" 2024-11-17 21:33:13.271 UTC client backend[18779] pg_regress/not_equal DETAIL: Key (cage, animal)=(123, lion) conflicts with existing key (cage, animal)=(123, zebra). 2024-11-17 21:33:13.271 UTC client backend[18779] pg_regress/not_equal STATEMENT: INSERT INTO zoo VALUES(123, 'lion'); 2024-11-17 21:33:13.325 UTC client backend[18788] pg_regress/partitions ERROR: conflicting key value violates exclusion constraint "parttmp_1_to_10_id_valid_at_excl" 2024-11-17 21:33:13.325 UTC client backend[18788] pg_regress/partitions DETAIL: Key (id, valid_at)=(2, [01-15-2000,02-01-2000)) conflicts with existing key (id, valid_at)=(2, [01-01-2000,02-01-2000)). 2024-11-17 21:33:13.325 UTC client backend[18788] pg_regress/partitions STATEMENT: insert into parttmp (id, valid_at) values (2, '[2000-01-15, 2000-02-01)'); 2024-11-17 21:33:13.330 UTC client backend[18788] pg_regress/partitions ERROR: cannot match partition key to index on column "id" using non-equal operator "<>" 2024-11-17 21:33:13.330 UTC client backend[18788] pg_regress/partitions STATEMENT: create table parttmp (id int, valid_at daterange, exclude using gist (id with <>, valid_at with &&)) partition by range (id); 2024-11-17 21:33:13.370 UTC client backend[18794] pg_regress/without_overlaps ERROR: conflicting key value violates exclusion constraint "temporal_rng_pk" 2024-11-17 21:33:13.370 UTC client backend[18794] pg_regress/without_overlaps DETAIL: Key (id, valid_at)=(1, [06-01-2000,01-01-2001)) conflicts with existing key (id, valid_at)=(1, [01-01-2000,01-01-2001)). 2024-11-17 21:33:13.370 UTC client backend[18794] pg_regress/without_overlaps STATEMENT: INSERT INTO temporal_rng VALUES (1, '[2000-06-01,2001-01-01)'); 2024-11-17 21:33:13.389 UTC client backend[18794] pg_regress/without_overlaps ERROR: insert or update on table "temporal_fk_rng2rng" violates foreign key constraint "temporal_fk_rng2rng_fk" 2024-11-17 21:33:13.389 UTC client backend[18794] pg_regress/without_overlaps DETAIL: Key (parent_id, valid_at)=(3, [01-01-2000,01-01-2001)) is not present in table "temporal_rng". 2024-11-17 21:33:13.389 UTC client backend[18794] pg_regress/without_overlaps STATEMENT: INSERT INTO temporal_fk_rng2rng VALUES (3, '[2000-01-01,2001-01-01)', 3); 2024-11-17 21:33:13.390 UTC client backend[18794] pg_regress/without_overlaps ERROR: insert or update on table "temporal_fk_rng2rng" violates foreign key constraint "temporal_fk_rng2rng_fk" 2024-11-17 21:33:13.390 UTC client backend[18794] pg_regress/without_overlaps DETAIL: Key (parent_id, valid_at)=(2, [01-01-2001,01-01-2002)) is not present in table "temporal_rng". 2024-11-17 21:33:13.390 UTC client backend[18794] pg_regress/without_overlaps STATEMENT: INSERT INTO temporal_fk_rng2rng VALUES (4, '[2001-01-01,2002-01-01)', 2); 2024-11-17 21:33:13.390 UTC client backend[18794] pg_regress/without_overlaps ERROR: insert or update on table "temporal_fk_rng2rng" violates foreign key constraint "temporal_fk_rng2rng_fk" 2024-11-17 21:33:13.390 UTC client backend[18794] pg_regress/without_overlaps DETAIL: Key (parent_id, valid_at)=(2, [01-01-2000,01-01-2002)) is not present in table "temporal_rng". 2024-11-17 21:33:13.390 UTC client backend[18794] pg_regress/without_overlaps STATEMENT: INSERT INTO temporal_fk_rng2rng VALUES (5, '[2000-01-01,2002-01-01)', 2); 2024-11-17 21:33:13.393 UTC postmaster[18675] LOG: received fast shutdown request 2024-11-17 21:33:13.393 UTC postmaster[18675] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 18675 0xa9f9d2 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89cdb7 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89b2b9 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89a68b at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres