2024-12-24 06:11:21.465 UTC postmaster[38395] LOG: starting PostgreSQL 18devel on x86_64-linux, compiled by gcc-12.2.0, 64-bit 2024-12-24 06:11:21.465 UTC postmaster[38395] LOG: listening on Unix socket "/tmp/pg_regress-TvWuUQ/.s.PGSQL.40010" 2024-12-24 06:11:21.468 UTC startup[38398] LOG: database system was shut down at 2024-12-24 06:07:37 UTC 2024-12-24 06:11:21.471 UTC postmaster[38395] LOG: database system is ready to accept connections 2024-12-24 06:11:21.606 UTC client backend[38408] pg_regress/create_index_acl ERROR: collation "coll" for encoding "UTF8" does not exist 2024-12-24 06:11:21.606 UTC client backend[38408] pg_regress/create_index_acl STATEMENT: ALTER TABLE s.x ADD CONSTRAINT underqualified EXCLUDE USING btree ((s.index_this_expr(y, s.const())) COLLATE coll WITH s.=) USING INDEX TABLESPACE regress_create_idx_tblspace WHERE (s.index_row_if(y)); 2024-12-24 06:11:21.607 UTC checkpointer[38396] LOG: checkpoint starting: immediate force wait 2024-12-24 06:11:21.638 UTC checkpointer[38396] LOG: checkpoint complete: wrote 983 buffers (6.0%), wrote 3 SLRU buffers; 1 WAL file(s) added, 0 removed, 0 recycled; write=0.014 s, sync=0.001 s, total=0.031 s; sync files=0, longest=0.000 s, average=0.000 s; distance=4625 kB, estimate=4625 kB; lsn=0/1C0FA20, redo lsn=0/1C0F9C8 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext ERROR: duplicate key value violates unique constraint "try_pkey" 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext DETAIL: Key (name)=(a) already exists. 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO try (name) VALUES ('a'); 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext ERROR: duplicate key value violates unique constraint "try_pkey" 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext DETAIL: Key (name)=(A) already exists. 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO try (name) VALUES ('A'); 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext ERROR: duplicate key value violates unique constraint "try_pkey" 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext DETAIL: Key (name)=(aB) already exists. 2024-12-24 06:11:21.685 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO try (name) VALUES ('aB'); 2024-12-24 06:11:21.718 UTC client backend[38413] pg_regress/citext ERROR: column "chr" is of type "char" but expression is of type citext at character 44 2024-12-24 06:11:21.718 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.718 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (chr) VALUES ('f'::citext); 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext ERROR: column "bytea" is of type bytea but expression is of type text at character 44 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (bytea) VALUES ('foo'::text); 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext ERROR: column "bytea" is of type bytea but expression is of type citext at character 44 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (bytea) VALUES ('foo'::citext); 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext ERROR: column "boolean" is of type boolean but expression is of type text at character 44 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.720 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (boolean) VALUES ('t'::text); 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext ERROR: column "boolean" is of type boolean but expression is of type citext at character 44 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (boolean) VALUES ('t'::citext); 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext ERROR: column "float8" is of type double precision but expression is of type text at character 44 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (float8) VALUES ('12.42'::text); 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext ERROR: column "float8" is of type double precision but expression is of type citext at character 44 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.721 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (float8) VALUES ('12.42'::citext); 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext ERROR: column "float4" is of type real but expression is of type text at character 44 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (float4) VALUES ('12.42'::text); 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext ERROR: column "float4" is of type real but expression is of type citext at character 44 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (float4) VALUES ('12.42'::citext); 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext ERROR: column "numeric" is of type numeric but expression is of type text at character 44 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.722 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (numeric) VALUES ('12.42'::text); 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext ERROR: column "numeric" is of type numeric but expression is of type citext at character 44 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (numeric) VALUES ('12.42'::citext); 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext ERROR: column "int8" is of type bigint but expression is of type text at character 44 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (int8) VALUES ('12'::text); 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext ERROR: column "int8" is of type bigint but expression is of type citext at character 44 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.723 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (int8) VALUES ('12'::citext); 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext ERROR: column "int4" is of type integer but expression is of type text at character 44 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (int4) VALUES ('12'::text); 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext ERROR: column "int4" is of type integer but expression is of type citext at character 44 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (int4) VALUES ('12'::citext); 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext ERROR: column "int2" is of type smallint but expression is of type text at character 44 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.724 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (int2) VALUES ('12'::text); 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext ERROR: column "int2" is of type smallint but expression is of type citext at character 44 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (int2) VALUES ('12'::citext); 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext ERROR: column "cidr" is of type cidr but expression is of type text at character 44 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (cidr) VALUES ('192.168.100.128/25'::text); 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext ERROR: column "cidr" is of type cidr but expression is of type citext at character 44 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.725 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (cidr) VALUES ('192.168.100.128/25'::citext); 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext ERROR: column "inet" is of type inet but expression is of type text at character 44 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (inet) VALUES ('192.168.100.128'::text); 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext ERROR: column "inet" is of type inet but expression is of type citext at character 44 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (inet) VALUES ('192.168.100.128'::citext); 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext ERROR: column "macaddr" is of type macaddr but expression is of type text at character 44 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.726 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (macaddr) VALUES ('08:00:2b:01:02:03'::text); 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext ERROR: column "macaddr" is of type macaddr but expression is of type citext at character 44 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (macaddr) VALUES ('08:00:2b:01:02:03'::citext); 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext ERROR: column "money" is of type money but expression is of type text at character 44 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (money) VALUES ('12'::text); 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext ERROR: column "money" is of type money but expression is of type citext at character 44 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.727 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (money) VALUES ('12'::citext); 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext ERROR: column "timestamp" is of type timestamp without time zone but expression is of type text at character 44 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (timestamp) VALUES ('1999-01-08 04:05:06'::text); 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext ERROR: column "timestamp" is of type timestamp without time zone but expression is of type citext at character 44 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (timestamp) VALUES ('1999-01-08 04:05:06'::citext); 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext ERROR: column "timestamptz" is of type timestamp with time zone but expression is of type text at character 44 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (timestamptz) VALUES ('1999-01-08 04:05:06'::text); 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext ERROR: column "timestamptz" is of type timestamp with time zone but expression is of type citext at character 44 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.728 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (timestamptz) VALUES ('1999-01-08 04:05:06'::citext); 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext ERROR: column "interval" is of type interval but expression is of type text at character 44 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (interval) VALUES ('1 hour'::text); 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext ERROR: column "interval" is of type interval but expression is of type citext at character 44 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (interval) VALUES ('1 hour'::citext); 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext ERROR: column "date" is of type date but expression is of type text at character 44 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.729 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (date) VALUES ('1999-01-08'::text); 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext ERROR: column "date" is of type date but expression is of type citext at character 44 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (date) VALUES ('1999-01-08'::citext); 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext ERROR: column "time" is of type time without time zone but expression is of type text at character 44 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (time) VALUES ('04:05:06'::text); 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext ERROR: column "time" is of type time without time zone but expression is of type citext at character 44 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (time) VALUES ('04:05:06'::citext); 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext ERROR: column "timetz" is of type time with time zone but expression is of type text at character 44 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.730 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (timetz) VALUES ('04:05:06'::text); 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext ERROR: column "timetz" is of type time with time zone but expression is of type citext at character 44 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (timetz) VALUES ('04:05:06'::citext); 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext ERROR: column "point" is of type point but expression is of type text at character 44 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (point) VALUES ('( 1 , 1)'::text); 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext ERROR: column "point" is of type point but expression is of type citext at character 44 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.731 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (point) VALUES ('( 1 , 1)'::citext); 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext ERROR: column "lseg" is of type lseg but expression is of type text at character 44 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (lseg) VALUES ('( 1 , 1 ) , ( 2 , 2 )'::text); 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext ERROR: column "lseg" is of type lseg but expression is of type citext at character 44 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (lseg) VALUES ('( 1 , 1 ) , ( 2 , 2 )'::citext); 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext ERROR: column "box" is of type box but expression is of type text at character 44 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.732 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (box) VALUES ('(0,0),(1,1)'::text); 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext ERROR: column "box" is of type box but expression is of type citext at character 44 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (box) VALUES ('(0,0),(1,1)'::citext); 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext ERROR: column "path" is of type path but expression is of type text at character 44 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (path) VALUES ('((0,0),(1,1),(2,0))'::text); 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext ERROR: column "path" is of type path but expression is of type citext at character 44 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (path) VALUES ('((0,0),(1,1),(2,0))'::citext); 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext ERROR: column "polygon" is of type polygon but expression is of type text at character 44 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.733 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (polygon) VALUES ('((0,0),(1,1))'::text); 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext ERROR: column "polygon" is of type polygon but expression is of type citext at character 44 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (polygon) VALUES ('((0,0),(1,1))'::citext); 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext ERROR: column "circle" is of type circle but expression is of type text at character 44 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (circle) VALUES ('((0,0),2)'::text); 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext ERROR: column "circle" is of type circle but expression is of type citext at character 44 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.734 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (circle) VALUES ('((0,0),2)'::citext); 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext ERROR: column "bit" is of type bit but expression is of type text at character 44 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (bit) VALUES ('101'::text); 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext ERROR: column "bit" is of type bit but expression is of type citext at character 44 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (bit) VALUES ('101'::citext); 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext ERROR: column "bitv" is of type bit varying but expression is of type text at character 44 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (bitv) VALUES ('101'::text); 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext ERROR: column "bitv" is of type bit varying but expression is of type citext at character 44 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.735 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (bitv) VALUES ('101'::citext); 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext ERROR: column "tsvector" is of type tsvector but expression is of type text at character 44 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (tsvector) VALUES ('the fat cat'::text); 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext ERROR: column "tsvector" is of type tsvector but expression is of type citext at character 44 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (tsvector) VALUES ('the fat cat'::citext); 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext ERROR: column "tsquery" is of type tsquery but expression is of type text at character 44 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.736 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (tsquery) VALUES ('fat & rat'::text); 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext ERROR: column "tsquery" is of type tsquery but expression is of type citext at character 44 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (tsquery) VALUES ('fat & rat'::citext); 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext ERROR: column "uuid" is of type uuid but expression is of type text at character 44 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (uuid) VALUES ('a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11'::text); 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext ERROR: column "uuid" is of type uuid but expression is of type citext at character 44 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext HINT: You will need to rewrite or cast the expression. 2024-12-24 06:11:21.737 UTC client backend[38413] pg_regress/citext STATEMENT: INSERT INTO caster (uuid) VALUES ('a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11'::citext); 2024-12-24 06:11:21.750 UTC client backend[38413] pg_regress/citext ERROR: regexp_match() does not support the "global" option 2024-12-24 06:11:21.750 UTC client backend[38413] pg_regress/citext HINT: Use the regexp_matches function instead. 2024-12-24 06:11:21.750 UTC client backend[38413] pg_regress/citext CONTEXT: SQL function "regexp_match" statement 1 2024-12-24 06:11:21.750 UTC client backend[38413] pg_regress/citext STATEMENT: SELECT regexp_match('foobarbequebazmorebarbequetoo'::citext, '(BAR)(BEQUE)'::citext, 'g') AS "error"; 2024-12-24 06:11:21.822 UTC postmaster[38395] LOG: received fast shutdown request 2024-12-24 06:11:21.822 UTC postmaster[38395] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 38395 postgres(ExceptionalCondition+0x56)[0x560a6a2a775a] postgres(+0xecad62)[0x560a69ebdd62] postgres(+0xecb2b8)[0x560a69ebe2b8] postgres(+0xecc17a)[0x560a69ebf17a] postgres(PostmasterMain+0x13f0)[0x560a69ec0bd9] postgres(main+0x28d)[0x560a69cf5061] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f76cd64624a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f76cd646305] postgres(_start+0x21)[0x560a698a0141]