public inbox for [email protected]  

help / color / mirror / Atom feed

Re: Does included columns part of the PK
8+ messages / 3 participants
[nested] [flat]

* Re: Does included columns part of the PK
@ 2026-03-15 15:34  Adrian Klaver <[email protected]>
  0 siblings, 1 reply; 8+ messages in thread

From: Adrian Klaver @ 2026-03-15 15:34 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; +Cc: David G. Johnston <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>

On 3/14/26 11:24 PM, Igor Korot wrote:
> Hi, Adrian,

> 
> Lets start with the beginning:
> 
> draft=# CREATE TABLE leagues_new(id serial, name varchar(100),
> drafttype smallint, scoringtype smallint, roundvalues smallint,
> leaguetype char(5), salary integer, benchplayers smallint, primary
> key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50,
> deduplicate_items = OFF ));
> CREATE TABLE
> draft=#

I think the above is for this thread:

https://www.postgresql.org/message-id/CA%2BFnnTyGEM-1mwxKPbwFTOodf%2BYUX%3DTxTmBPY5S%3DYh1h%3DoVY9A%...




-- 
Adrian Klaver
[email protected]






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Does included columns part of the PK
@ 2026-03-16 01:23  Igor Korot <[email protected]>
  parent: Adrian Klaver <[email protected]>
  0 siblings, 2 replies; 8+ messages in thread

From: Igor Korot @ 2026-03-16 01:23 UTC (permalink / raw)
  To: Adrian Klaver <[email protected]>; +Cc: David G. Johnston <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>

Hi, Adrian,

Here is the log file from running in ODBC mode: https://bpa.st/Z2DWG

Thank you.

On Sun, Mar 15, 2026 at 10:34 AM Adrian Klaver
<[email protected]> wrote:
>
> On 3/14/26 11:24 PM, Igor Korot wrote:
> > Hi, Adrian,
>
> >
> > Lets start with the beginning:
> >
> > draft=# CREATE TABLE leagues_new(id serial, name varchar(100),
> > drafttype smallint, scoringtype smallint, roundvalues smallint,
> > leaguetype char(5), salary integer, benchplayers smallint, primary
> > key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50,
> > deduplicate_items = OFF ));
> > CREATE TABLE
> > draft=#
>
> I think the above is for this thread:
>
> https://www.postgresql.org/message-id/CA%2BFnnTyGEM-1mwxKPbwFTOodf%2BYUX%3DTxTmBPY5S%3DYh1h%3DoVY9A%...
>
>
>
>
> --
> Adrian Klaver
> [email protected]






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Does included columns part of the PK
@ 2026-03-16 13:53  Greg Sabino Mullane <[email protected]>
  parent: Igor Korot <[email protected]>
  1 sibling, 1 reply; 8+ messages in thread

From: Greg Sabino Mullane @ 2026-03-16 13:53 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; +Cc: Adrian Klaver <[email protected]>; David G. Johnston <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>

Please don't send links to external sites. Since I've already clicked on
it, I'll put it here for the archives as an attachment.

2026-03-15 19:52:02.787 CDT,,,6586,,69b75432.19ba,1,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"ending log output to stderr",,"Future log output will go to log destination ""csvlog"".",,,,,,,"","postmaster",,0
2026-03-15 19:52:02.787 CDT,,,6586,,69b75432.19ba,2,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"starting PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (Gentoo 13.2.1_p20240210 p14) 13.2.1 20240210, 64-bit",,,,,,,,,"","postmaster",,0
2026-03-15 19:52:02.791 CDT,,,6586,,69b75432.19ba,3,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"listening on IPv6 address ""::1"", port 5432",,,,,,,,,"","postmaster",,0
2026-03-15 19:52:02.792 CDT,,,6586,,69b75432.19ba,4,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"listening on IPv4 address ""127.0.0.1"", port 5432",,,,,,,,,"","postmaster",,0
2026-03-15 19:52:02.827 CDT,,,6586,,69b75432.19ba,5,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"listening on Unix socket ""/run/postgresql/.s.PGSQL.5432""",,,,,,,,,"","postmaster",,0
2026-03-15 19:52:02.931 CDT,,,6590,,69b75432.19be,1,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"database system was shut down at 2026-03-15 19:52:01 CDT",,,,,,,,,"","startup",,0
2026-03-15 19:52:02.986 CDT,,,6586,,69b75432.19ba,6,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"database system is ready to accept connections",,,,,,,,,"","postmaster",,0
2026-03-15 19:57:03.026 CDT,,,6588,,69b75432.19bc,1,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"checkpoint starting: time",,,,,,,,,"","checkpointer",,0
2026-03-15 19:57:03.198 CDT,,,6588,,69b75432.19bc,2,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.035 s, sync=0.024 s, total=0.172 s; sync files=2, longest=0.015 s, average=0.012 s; distance=0 kB, estimate=0 kB; lsn=0/1D55808, redo lsn=0/1D557D0",,,,,,,,,"","checkpointer",,0
2026-03-15 20:02:58.897 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,1,"idle",2026-03-15 20:02:58 CDT,3/44,0,LOG,00000,"statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.898 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,2,"idle",2026-03-15 20:02:58 CDT,3/45,0,LOG,00000,"statement: select oid, typbasetype from pg_type where typname = 'lo'",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.905 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,3,"idle",2026-03-15 20:02:58 CDT,3/46,0,LOG,00000,"statement: SELECT version() AS version, split_part( split_part( version(), ' ', 2 ) , '.', 1 ) AS major, split_part( split_part( version(), ' ', 2 ), '.', 2 ) AS minor;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.909 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,4,"idle",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: BEGIN;BEGIN",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.909 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,5,"BEGIN",2026-03-15 20:02:58 CDT,3/47,0,WARNING,25001,"there is already a transaction in progress",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.910 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,6,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE TABLE IF NOT EXISTS abcatcol(abc_tnam char(129) NOT NULL, abc_tid integer, abc_ownr char(129) NOT NULL, abc_cnam char(129) NOT NULL, abc_cid smallint, abc_labl char(254), abc_lpos smallint, abc_hdr char(254), abc_hpos smallint, abc_itfy smallint, abc_mask char(31), abc_case smallint, abc_hght smallint, abc_wdth smallint, abc_ptrn char(31), abc_bmap char(1), abc_init char(254), abc_cmnt char(254), abc_edit char(31), abc_tag char(254), PRIMARY KEY( abc_tnam, abc_ownr, abc_cnam ));",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.915 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,7,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE TABLE IF NOT EXISTS abcatedt(abe_name char(30) NOT NULL, abe_edit char(254), abe_type smallint, abe_cntr integer, abe_seqn smallint NOT NULL, abe_flag integer, abe_work char(32), PRIMARY KEY( abe_name, abe_seqn ));",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.916 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,8,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE TABLE IF NOT EXISTS abcatfmt(abf_name char(30) NOT NULL, abf_frmt char(254), abf_type smallint, abf_cntr integer, PRIMARY KEY( abf_name ));",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.917 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,9,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE TABLE IF NOT EXISTS abcatvld(abv_name char(30) NOT NULL, abv_vald char(254), abv_type smallint, abv_cntr integer, abv_msg char(254), PRIMARY KEY( abv_name ));",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.918 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,10,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE TABLE IF NOT EXISTS abcattbl(abt_os smallint, abt_tnam char(129) NOT NULL, abt_tid integer, abt_ownr char(129) NOT NULL, abd_fhgt smallint, abd_fwgt smallint, abd_fitl char(1), abd_funl char(1), abd_strke smallint, abd_fchr smallint, abd_fptc smallint, abd_ffce char(18), abh_fhgt smallint, abh_fwgt smallint, abh_fitl char(1), abh_funl char(1), abh_strke smallint, abh_fchr smallint, abh_fptc smallint, abh_ffce char(18), abl_fhgt smallint, abl_fwgt smallint, abl_fitl char(1), abl_funl char(1), abl_strke smallint, abl_fchr smallint, abl_fptc smallint, abl_ffce char(18), abt_cmnt char(254), PRIMARY KEY( abt_tnam, abt_ownr ));",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.920 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,11,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE UNIQUE INDEX IF NOT EXISTS abcatc_x ON abcatcol( abc_tnam, abc_ownr, abc_cnam );",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.923 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,12,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE UNIQUE INDEX IF NOT EXISTS abcate_x ON abcatedt( abe_name, abe_seqn );",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.925 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,13,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE UNIQUE INDEX IF NOT EXISTS abcatf_x ON abcatfmt( abf_name );",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.926 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,14,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE UNIQUE INDEX IF NOT EXISTS abcatt_x ON abcattbl( abt_os, abt_tnam, abt_ownr );",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.927 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,15,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;CREATE UNIQUE INDEX IF NOT EXISTS abcatv_x ON abcatvld( abv_name );",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.928 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,16,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '(General)', '(General)', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.930 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,17,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '0', '0', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.932 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,18,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '0.00', '0.00', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.932 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,19,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '#.##0', '#.##0', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.933 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,20,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '#.##0,00', '#.##0,00', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.935 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,21,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '$#.##0;[$#.##0]', '$#.##0;[$#.##0]', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.936 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,22,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '$#.##0;|RED|[$#.##0]', '$#.##0;|RED|[$#.##0]', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.937 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,23,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '$#.##0,00;[$#.##0,00]', '$#.##0,00;[$#.##0,00]', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.938 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,24,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '$#.##0,00;|RED|[$#.##0,00]', '$#.##0,00;|RED|[$#.##0,00]', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.939 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,25,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '0%', '0%', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.940 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,26,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '0.00%', '0.00%', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.941 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,27,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( '0.00E+00', '0.00E+00', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.942 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,28,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'm/d/yy', 'm/d/yy', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.943 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,29,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'd-mmm-yy', 'd-mmm-yy', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.943 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,30,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'd-mmm', 'd-mmm', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.944 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,31,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'mmm-yy', 'mmm-yy', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.945 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,32,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'h:mm AM/PM', 'h:mm AM/PM', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.946 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,33,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'h:mm:ss AM/PM', 'h:mm:ss AM/PM', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.947 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,34,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'h:mm:ss', 'h:mm:ss', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.948 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,35,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'Phone_format', '(@@@)) @@@-@@@@', 80, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.949 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,36,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'm-d-yy', 'm-d-yy', 84, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.949 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,37,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'soc_sec_number', '@@@-@@-@@@@', 80, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.950 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,38,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'mm/dd/yyyy', 'mm/dd/yyyy', 82, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.951 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,39,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'salary', '$###,##0.00', 81, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.952 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,40,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatfmt VALUES( 'mm-dd-yyyy', 'mm-dd-yyyy', 82, 0 ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.953 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,41,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatvld VALUES( 'Multiple_of_100', 'CHECK( mod( @column, 100 ) = 0 )', 81, 3, 'The department number must be ') ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.955 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,42,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatvld VALUES( 'Positive_number', 'CHECK( @column > 0 )', 81, 6, 'Sorry! The value must be greater than 0') ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.955 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,43,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatvld VALUES( 'Y_or_N', 'CHECK( @column IN ( ""Y"", ""y"", ""N"", ""n"" )', 81, 6, '') ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.956 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,44,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatvld VALUES( 'must_be_numer', 'CHECK( isNumer( @column )', 80, 0, '') ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.956 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,45,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatvld VALUES( 'valid status', 'CHECK( @status == ""ALT"" )', 80, 3, '') ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.957 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,46,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( '###-##-####', '###-##-####', 90, 1, 1, 32, '00' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.958 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,47,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( '###,###.00', '###,###.00', 90, 1, 1, 32, '10' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.959 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,48,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( '#####', '#####', 90, 1, 1, 32, '10' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.959 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,49,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'BenefitsCheckBox', NULL, 85, 4, 1, 536870916, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.960 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,50,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'BenefitsCheckBox', 'Y', 85, 4, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.961 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,51,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'BenefitsCheckBox', 'N', 85, 4, 3, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.961 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,52,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', '0', 87, 3, 1, -201326590, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.961 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,53,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'White', 87, 3, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.962 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,54,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'White', 87, 3, 3, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.962 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,55,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Black', 87, 3, 4, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.963 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,56,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Black', 87, 3, 5, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.964 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,57,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Purple', 87, 3, 6, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.965 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,58,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Purple', 87, 3, 7, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.966 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,59,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Orange', 87, 3, 8, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.966 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,60,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Orange', 87, 3, 9, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.968 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,61,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Green', 87, 3, 10, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.969 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,62,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Green', 87, 3, 11, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.970 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,63,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Blue', 87, 3, 12, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.971 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,64,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Blue', 87, 3, 13, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.972 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,65,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Yellow', 87, 3, 14, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.973 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,66,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Yellow', 87, 3, 15, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.974 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,67,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Red', 87, 3, 16, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.975 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,68,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Color List', 'Red', 87, 3, 17, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.976 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,69,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Customers', 'd_dddw_cust', 88, 2, 1, 536870928, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.977 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,70,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Customers', 'id', 88, 2, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.978 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,71,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Customers', 'id', 88, 2, 3, 0, '400' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.979 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,72,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Day Care', 'Day Care', 85, 4, 1, 536870916, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.980 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,73,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Day Care', 'Y', 85, 4, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.981 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,74,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Day Care', 'N', 85, 4, 3, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.982 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,75,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DD/MM/YY', 'DD/MM/YY', 90, 1, 1, 32, '20' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.982 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,76,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DD/MM/YY HH:MM:SS', 'DD/MM/YY HH:MM:SS', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.984 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,77,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DD/MM/YY HH:MM:SS:FFFFFF', 'DD/MM/YY HH:MM:SS:FFFFFF', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.985 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,78,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DD/MM/YYYY', 'DD/MM/YYYY', 90, 1, 1, 32, '20' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.986 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,79,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DD/MM/YYYY HH:MM:SS', 'DD/MM/YY HH::MM:SS', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.987 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,80,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DD/MMM/YY', 'DD/MMM/YY', 90, 1, 1, 32, '20' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.988 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,81,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DD/MMM/YY HH:MM:SS', 'DD/MMM/YY HH:MM:SS', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.989 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,82,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DDD/YY', 'DDD/YY', 90, 1, 1, 32, '20' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.990 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,83,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DDD/YY HH:MM:SS', 'DDD/YY HH:MM:SS', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.991 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,84,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DDD/YYYY', 'DDD/YYYY', 90, 1, 1, 32, '20' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.992 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,85,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'DDD/YYYY HH:MM:SS', 'DDD/YYYY HH:MM:SS', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.993 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,86,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Department List', 'd_dddw_dept', 88, 10, 1, 536870928, '0' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.993 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,87,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Department List', 'dept_id', 88, 10, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.994 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,88,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Department List', 'dept_d', 88, 10, 3, 0, '300' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.995 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,89,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Dollars with cents', '$###,###,###.00', 90, 2, 1, 32, '00' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.996 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,90,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Employee Status', '1', 86, 3, 1, 1073741832, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.997 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,91,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Employee Status', 'Active', 86, 3, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.998 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,92,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Employee Status', 'A', 86, 3, 3, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:58.999 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,93,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Employee Status', 'Terminated', 86, 3, 4, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.000 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,94,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Employee Status', 'T', 86, 3, 5, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.001 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,95,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Employee Status', 'On Leave', 86, 3, 6, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.002 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,96,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Employee Status', 'L', 86, 3, 7, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.004 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,97,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'employees', 'd_dddw_sales_reps', 88, 3, 1, 536870928, '0' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.004 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,98,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'employees', 'emp_id', 88, 3, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.005 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,99,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'employees', 'emp_id', 88, 3, 3, 0, '400' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.006 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,100,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Financial Codes', 'd_dddw_fin_code', 88, 3, 1, 536870928, '0' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.007 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,101,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Financial Codes', 'code', 88, 3, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.007 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,102,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Financial Codes', 'code', 88, 3, 3, 0, '700' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.008 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,103,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Health Insurance', 'health insurance', 85, 3, 1, 536870928, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.009 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,104,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Health Insurance', 'Y', 85, 3, 2, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.009 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,105,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'Health Insurance', 'N', 85, 3, 3, 0, NULL ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.010 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,106,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.011 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,107,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS:FFF', 'HH:MM:SS:FFF', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.011 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,108,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS:FFFFFF', 'HH:MM:SS:FFFFFF', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.012 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,109,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'JJJ/YY', 'JJJ/YY', 90, 1, 1, 32, '20' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.013 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,110,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'JJJ/YY HH:MM:SS', 'JJJ/YY HH:MM:SS', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.014 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,111,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'JJJ/YYYY', 'JJJ/YYYY', 90, 1, 1, 32, '40' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.015 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,112,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.015 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,113,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.016 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,114,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.017 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,115,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.018 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,116,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.018 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,117,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.019 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,118,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.020 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,119,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.022 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,120,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.023 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,121,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.024 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,122,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80;INSERT INTO abcatedt VALUES( 'HH:MM:SS', 'HH:MM:SS', 90, 1, 1, 32, '30' ) ON CONFLICT DO NOTHING;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.024 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,123,"idle in transaction",2026-03-15 20:02:58 CDT,3/47,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.027 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,124,"idle",2026-03-15 20:02:58 CDT,3/48,0,LOG,00000,"statement: select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v', 'm', 'f', 'p') and nspname like '%' and relname like '%' and nspname not in ('pg_catalog', 'information_schema', 'pg_toast', 'pg_temp_1') and n.oid = relnamespace order by nspname, relname",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.038 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,125,"idle",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: BEGIN;BEGIN",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.038 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,126,"BEGIN",2026-03-15 20:02:58 CDT,3/49,0,WARNING,25001,"there is already a transaction in progress",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.040 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,127,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.045 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,128,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.abcatcol', $3 = 'abcatcol', $4 = 'public', $5 = 'abcatcol', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.047 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,129,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.050 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,130,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.abcatedt', $3 = 'abcatedt', $4 = 'public', $5 = 'abcatedt', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.051 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,131,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.053 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,132,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.abcatfmt', $3 = 'abcatfmt', $4 = 'public', $5 = 'abcatfmt', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.054 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,133,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.056 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,134,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.abcattbl', $3 = 'abcattbl', $4 = 'public', $5 = 'abcattbl', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.057 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,135,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.060 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,136,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.abcatvld', $3 = 'abcatvld', $4 = 'public', $5 = 'abcatvld', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.061 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,137,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.063 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,138,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.abcß', $3 = 'abcß', $4 = 'public', $5 = 'abcß', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.064 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,139,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.065 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,140,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.leagues', $3 = 'leagues', $4 = 'public', $5 = 'leagues', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.067 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,141,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.067 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,142,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.leagues_new', $3 = 'leagues_new', $4 = 'public', $5 = 'leagues_new', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.069 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,143,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.069 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,144,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.leaguescorehitter', $3 = 'leaguescorehitter', $4 = 'public', $5 = 'leaguescorehitter', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.071 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,145,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.071 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,146,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.leaguescorepitcher', $3 = 'leaguescorepitcher', $4 = 'public', $5 = 'leaguescorepitcher', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.073 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,147,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.073 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,148,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.owners', $3 = 'owners', $4 = 'public', $5 = 'owners', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.075 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,149,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.075 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,150,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.pictures', $3 = 'pictures', $4 = 'public', $5 = 'pictures', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.076 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,151,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.077 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,152,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.playerdraft', $3 = 'playerdraft', $4 = 'public', $5 = 'playerdraft', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.079 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,153,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.079 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,154,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.playerposition', $3 = 'playerposition', $4 = 'public', $5 = 'playerposition', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.080 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,155,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.081 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,156,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.playerpositioninleague', $3 = 'playerpositioninleague', $4 = 'public', $5 = 'playerpositioninleague', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.082 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,157,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.083 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,158,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.players', $3 = 'players', $4 = 'public', $5 = 'players', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.084 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,159,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.084 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,160,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.playerscorehits', $3 = 'playerscorehits', $4 = 'public', $5 = 'playerscorehits', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.085 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,161,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.086 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,162,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.playerscorepitches', $3 = 'playerscorepitches', $4 = 'public', $5 = 'playerscorepitches', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.087 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,163,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.088 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,164,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.playersinleague', $3 = 'playersinleague', $4 = 'public', $5 = 'playersinleague', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.089 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,165,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.089 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,166,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.positions', $3 = 'positions', $4 = 'public', $5 = 'positions', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.090 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,167,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.091 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,168,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.positionsforleague', $3 = 'positionsforleague', $4 = 'public', $5 = 'positionsforleague', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.092 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,169,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.092 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,170,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.scorehits', $3 = 'scorehits', $4 = 'public', $5 = 'scorehits', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.093 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,171,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.094 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,172,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.scorehitsforleague', $3 = 'scorehitsforleague', $4 = 'public', $5 = 'scorehitsforleague', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.095 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,173,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.095 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,174,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.scorepitch', $3 = 'scorepitch', $4 = 'public', $5 = 'scorepitch', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.096 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,175,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.097 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,176,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.scorepitchforleague', $3 = 'scorepitchforleague', $4 = 'public', $5 = 'scorepitchforleague', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.098 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,177,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.098 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,178,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.targetshits', $3 = 'targetshits', $4 = 'public', $5 = 'targetshits', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.100 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,179,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.100 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,180,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.targetspitches', $3 = 'targetspitches', $4 = 'public', $5 = 'targetspitches', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.101 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,181,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.101 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,182,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.teams', $3 = 'teams', $4 = 'public', $5 = 'teams', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.103 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,183,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: RELEASE _EXEC_SVP_0x61e00046bc80;SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.103 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,184,"INSERT",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"execute _PLAN0x6190006b3a80: INSERT INTO abcattbl VALUES( $1, $2, (SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace AND c.relname = $3 AND nc.nspname = $4), COALESCE((SELECT tableowner FROM pg_tables WHERE tablename = $5 AND schemaname = $6), 'postgres'), 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', 8, 400, 'N', 'N', 0, 34, 0, 'Serif', '' ) ON CONFLICT DO NOTHING","parameters: $1 = '1', $2 = 'public.teamsforleague', $3 = 'teamsforleague', $4 = 'public', $5 = 'teamsforleague', $6 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:02:59.104 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,185,"idle in transaction",2026-03-15 20:02:58 CDT,3/49,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.104 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,186,"idle",2026-03-15 20:02:58 CDT,3/50,0,LOG,00000,"statement: DEALLOCATE ""_PLAN0x6190006b3a80""",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.105 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,187,"idle",2026-03-15 20:02:58 CDT,3/51,0,LOG,00000,"statement: BEGIN;SELECT * FROM abcatvld;",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.108 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,188,"idle in transaction",2026-03-15 20:02:58 CDT,3/51,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.146 CDT,"postgres","draft",19116,"::1:52784",69b756c3.4aac,1,"idle",2026-03-15 20:02:59 CDT,4/2,0,LOG,00000,"statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation",,,,,,,,,"","client backend",,0
2026-03-15 20:02:59.147 CDT,"postgres","draft",19116,"::1:52784",69b756c3.4aac,2,"idle",2026-03-15 20:02:59 CDT,4/3,0,LOG,00000,"statement: select oid, typbasetype from pg_type where typname = 'lo'",,,,,,,,,"","client backend",,0
2026-03-15 20:03:04.179 CDT,"postgres","draft",19219,"::1:43002",69b756c8.4b13,1,"idle",2026-03-15 20:03:04 CDT,4/7,0,LOG,00000,"statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation",,,,,,,,,"","client backend",,0
2026-03-15 20:03:04.180 CDT,"postgres","draft",19219,"::1:43002",69b756c8.4b13,2,"idle",2026-03-15 20:03:04 CDT,4/8,0,LOG,00000,"statement: select oid, typbasetype from pg_type where typname = 'lo'",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.240 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,189,"idle",2026-03-15 20:02:58 CDT,3/52,0,LOG,00000,"statement: BEGIN",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.249 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,190,"idle in transaction",2026-03-15 20:02:58 CDT,3/52,0,LOG,00000,"statement: show max_identifier_length",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.251 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,191,"idle in transaction",2026-03-15 20:02:58 CDT,3/52,0,LOG,00000,"statement: SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.255 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,192,"SELECT",2026-03-15 20:02:58 CDT,3/52,0,LOG,00000,"execute _PLAN0x61900085ac80: SELECT u.usename FROM pg_class c, pg_user u, pg_namespace n WHERE n.oid = c.relnamespace AND u.usesysid = c.relowner AND relname = $1 AND n.nspname = $2","parameters: $1 = 'leagues_new', $2 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:03:07.257 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,193,"idle in transaction",2026-03-15 20:02:58 CDT,3/52,0,LOG,00000,"statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, 0, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 12014) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.280 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,194,"idle in transaction",2026-03-15 20:02:58 CDT,3/52,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.281 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,195,"idle",2026-03-15 20:02:58 CDT,3/53,0,LOG,00000,"statement: DEALLOCATE ""_PLAN0x61900085ac80""",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.285 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,196,"idle",2026-03-15 20:02:58 CDT,3/54,0,LOG,00000,"statement: BEGIN;SELECT * FROM draft.public.leagues_new",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.289 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,197,"idle in transaction",2026-03-15 20:02:58 CDT,3/54,0,LOG,00000,"statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, 0, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 16839) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.307 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,198,"idle in transaction",2026-03-15 20:02:58 CDT,3/54,0,LOG,00000,"statement: ROLLBACK",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.312 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,199,"idle",2026-03-15 20:02:58 CDT,3/55,0,LOG,00000,"statement: select	'draft'::name as ""PKTABLE_CAT"",
	n2.nspname as ""PKTABLE_SCHEM"",
	c2.relname as ""PKTABLE_NAME"",
	a2.attname as ""PKCOLUMN_NAME"",
	'draft'::name as ""FKTABLE_CAT"",
	n1.nspname as ""FKTABLE_SCHEM"",
	c1.relname as ""FKTABLE_NAME"",
	a1.attname as ""FKCOLUMN_NAME"",
	i::int2 as ""KEY_SEQ"",
	case ref.confupdtype
		when 'c' then 0::int2
		when 'n' then 2::int2
		when 'd' then 4::int2
		when 'r' then 1::int2
		else 3::int2
	end as ""UPDATE_RULE"",
	case ref.confdeltype
		when 'c' then 0::int2
		when 'n' then 2::int2
		when 'd' then 4::int2
		when 'r' then 1::int2
		else 3::int2
	end as ""DELETE_RULE"",
	ref.conname as ""FK_NAME"",
	cn.conname as ""PK_NAME"",
	case
		when ref.condeferrable then
			case
			when ref.condeferred then 5::int2
			else 6::int2
			end
		else 7::int2
	end as ""DEFERRABILITY""
 from
 ((((((( (select cn.oid, conrelid, conkey, confrelid, confkey,
	 generate_series(array_lower(conkey, 1), array_upper(conkey, 1)) as i,
	 confupdtype, confdeltype, conname,
	 condeferrable, condeferred
  from pg_catalog.pg_constraint cn,
	pg_catalog.pg_class c,
	pg_catalog.pg_namespace n
  where contype = 'f' 
   and  conrelid = c.oid
   and  relname = 'leagues_new'
   and  n.oid = c.relnamespace
   and  n.nspname = 'public'
 ) ref
 inner join pg_catalog.pg_class c1
  on c1.oid = ref.conrelid)
 inner join pg_catalog.pg_namespace n1
  on  n1.oid = c1.relnamespace)
 inner join pg_catalog.pg_attribute a1
  on  a1.attrelid = c1.oid
  and  a1.attnum = conkey[i])
 inner join pg_catalog.pg_class c2
  on  c2.oid = ref.confrelid)
 inner join pg_catalog.pg_namespace n2
  on  n2.oid = c2.relnamespace)
 inner join pg_catalog.pg_attribute a2
  on  a2.attrelid = c2.oid
  and  a2.attnum = confkey[i])
 left outer join pg_catalog.pg_constraint cn
  on cn.conrelid = ref.confrelid
  and cn.contype = 'p')
  order by ref.oid, ref.i",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.353 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,200,"idle",2026-03-15 20:02:58 CDT,3/56,0,LOG,00000,"statement: select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = 'leagues_new' AND n.nspname = 'public' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.363 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,201,"idle",2026-03-15 20:02:58 CDT,3/57,0,LOG,00000,"statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, 0, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like 'leagues_new' and n.nspname like 'public') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.373 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,202,"idle",2026-03-15 20:02:58 CDT,3/58,0,LOG,00000,"statement: BEGIN",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.379 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,203,"idle in transaction",2026-03-15 20:02:58 CDT,3/58,0,LOG,00000,"statement: SAVEPOINT _EXEC_SVP_0x61e00046bc80",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.382 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,204,"SELECT",2026-03-15 20:02:58 CDT,3/58,0,LOG,00000,"execute _PLAN0x61900086b580: SELECT indexname FROM draft.pg_catalog.pg_indexes WHERE tablename = $1 AND schemaname = $2","parameters: $1 = 'leagues_new', $2 = 'public'",,,,,,,,"","client backend",,0
2026-03-15 20:03:07.383 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,205,"idle in transaction",2026-03-15 20:02:58 CDT,3/58,0,LOG,00000,"statement: ROLLBACK",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.384 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,206,"idle",2026-03-15 20:02:58 CDT,3/59,0,LOG,00000,"statement: DEALLOCATE ""_PLAN0x61900086b580""",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.385 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,207,"idle",2026-03-15 20:02:58 CDT,3/60,0,LOG,00000,"statement: BEGIN;SELECT abd_fhgt, abd_fwgt, abd_fitl, abd_funl, abd_strke, abd_fchr, abd_fptc, rtrim(abd_ffce), abh_fhgt, abh_fwgt, abh_fitl, abh_funl, abh_strke, abh_fchr, abh_fptc, rtrim(abh_ffce), abl_fhgt, abl_fwgt, abl_fitl, abl_funl, abl_strke, abl_fchr, abl_fptc, rtrim(abl_ffce), rtrim(abt_cmnt) FROM abcattbl WHERE rtrim(abt_tnam) = 'public.leagues_new' AND rtrim(abt_ownr) = 'postgres' AND abt_os = 1;",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.395 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,208,"idle in transaction",2026-03-15 20:02:58 CDT,3/60,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.398 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,209,"idle",2026-03-15 20:02:58 CDT,3/61,0,LOG,00000,"statement: BEGIN",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.409 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,210,"SELECT",2026-03-15 20:02:58 CDT,3/61,0,LOG,00000,"execute _PLAN0x61900086e780: SELECT c.relname AS name, ixs.tablespace AS tbspace, am.amname AS type, ARRAY(SELECT a.attname FROM pg_attribute a WHERE a.attrelid = idx.indrelid AND a.attnum = ANY(idx.indkey) AND a.attnum > 0 ORDER BY array_position(idx.indkey, a.attnum) OFFSET idx.indnkeyatts) AS included, c.reloptions AS storage FROM pg_am am, pg_index idx, pg_class c, pg_namespace n, pg_class t, pg_indexes ixs WHERE am.oid = c.relam AND ixs.indexname = c.relname AND c.oid = idx.indexrelid AND t.oid = idx.indrelid AND n.oid = c.relnamespace AND idx.indisprimary AND n.nspname = $1 AND t.relname = $2","parameters: $1 = 'public', $2 = 'leagues_new'",,,,,,,,"","client backend",,0
2026-03-15 20:03:07.415 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,211,"idle in transaction",2026-03-15 20:02:58 CDT,3/61,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:03:07.417 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,212,"idle",2026-03-15 20:02:58 CDT,3/62,0,LOG,00000,"statement: DEALLOCATE ""_PLAN0x61900086e780""",,,,,,,,,"","client backend",,0
2026-03-15 20:03:09.211 CDT,"postgres","draft",19324,"::1:43004",69b756cd.4b7c,1,"idle",2026-03-15 20:03:09 CDT,4/10,0,LOG,00000,"statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation",,,,,,,,,"","client backend",,0
2026-03-15 20:03:09.213 CDT,"postgres","draft",19324,"::1:43004",69b756cd.4b7c,2,"idle",2026-03-15 20:03:09 CDT,4/11,0,LOG,00000,"statement: select oid, typbasetype from pg_type where typname = 'lo'",,,,,,,,,"","client backend",,0
2026-03-15 20:03:13.870 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,213,"idle",2026-03-15 20:02:58 CDT,3/63,0,LOG,00000,"statement: BEGIN;SELECT abd_fhgt, abd_fwgt, abd_fitl, abd_funl, abd_strke, abd_fchr, abd_fptc, rtrim(abd_ffce), abh_fhgt, abh_fwgt, abh_fitl, abh_funl, abh_strke, abh_fchr, abh_fptc, rtrim(abh_ffce), abl_fhgt, abl_fwgt, abl_fitl, abl_funl, abl_strke, abl_fchr, abl_fptc, rtrim(abl_ffce), rtrim(abt_cmnt) FROM abcattbl WHERE rtrim(abt_tnam) = 'public.leagues_new' AND rtrim(abt_ownr) = 'postgres' AND abt_os = 1;",,,,,,,,,"","client backend",,0
2026-03-15 20:03:13.878 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,214,"idle in transaction",2026-03-15 20:02:58 CDT,3/63,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:03:13.883 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,215,"idle",2026-03-15 20:02:58 CDT,3/64,0,LOG,00000,"statement: BEGIN",,,,,,,,,"","client backend",,0
2026-03-15 20:03:13.895 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,216,"SELECT",2026-03-15 20:02:58 CDT,3/64,0,LOG,00000,"execute _PLAN0x6190008eda80: SELECT c.relname AS name, ixs.tablespace AS tbspace, am.amname AS type, ARRAY(SELECT a.attname FROM pg_attribute a WHERE a.attrelid = idx.indrelid AND a.attnum = ANY(idx.indkey) AND a.attnum > 0 ORDER BY array_position(idx.indkey, a.attnum) OFFSET idx.indnkeyatts) AS included, c.reloptions AS storage FROM pg_am am, pg_index idx, pg_class c, pg_namespace n, pg_class t, pg_indexes ixs WHERE am.oid = c.relam AND ixs.indexname = c.relname AND c.oid = idx.indexrelid AND t.oid = idx.indrelid AND n.oid = c.relnamespace AND idx.indisprimary AND n.nspname = $1 AND t.relname = $2","parameters: $1 = 'public', $2 = 'leagues_new'",,,,,,,,"","client backend",,0
2026-03-15 20:03:13.899 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,217,"idle in transaction",2026-03-15 20:02:58 CDT,3/64,0,LOG,00000,"statement: COMMIT",,,,,,,,,"","client backend",,0
2026-03-15 20:03:13.900 CDT,"postgres","draft",19114,"::1:52768",69b756c2.4aaa,218,"idle",2026-03-15 20:02:58 CDT,3/65,0,LOG,00000,"statement: DEALLOCATE ""_PLAN0x6190008eda80""",,,,,,,,,"","client backend",,0
2026-03-15 20:03:14.248 CDT,"postgres","draft",19439,"::1:35606",69b756d2.4bef,1,"idle",2026-03-15 20:03:14 CDT,4/13,0,LOG,00000,"statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation",,,,,,,,,"","client backend",,0
2026-03-15 20:03:14.250 CDT,"postgres","draft",19439,"::1:35606",69b756d2.4bef,2,"idle",2026-03-15 20:03:14 CDT,4/14,0,LOG,00000,"statement: select oid, typbasetype from pg_type where typname = 'lo'",,,,,,,,,"","client backend",,0
2026-03-15 20:03:19.395 CDT,"postgres","draft",19536,"::1:35610",69b756d7.4c50,1,"idle",2026-03-15 20:03:19 CDT,4/16,0,LOG,00000,"statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation",,,,,,,,,"","client backend",,0
2026-03-15 20:03:19.397 CDT,"postgres","draft",19536,"::1:35610",69b756d7.4c50,2,"idle",2026-03-15 20:03:19 CDT,4/17,0,LOG,00000,"statement: select oid, typbasetype from pg_type where typname = 'lo'",,,,,,,,,"","client backend",,0
2026-03-15 20:07:03.398 CDT,,,6588,,69b75432.19bc,3,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"checkpoint starting: time",,,,,,,,,"","checkpointer",,0
2026-03-15 20:07:03.571 CDT,,,6588,,69b75432.19bc,4,,2026-03-15 19:52:02 CDT,,0,LOG,00000,"checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.018 s, sync=0.014 s, total=0.173 s; sync files=1, longest=0.014 s, average=0.014 s; distance=0 kB, estimate=0 kB; lsn=0/1D55950, redo lsn=0/1D55918",,,,,,,,,"","checkpointer",,0


Attachments:

  [text/plain] odbc.txt (89.2K, 3-odbc.txt)
  download

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Does included columns part of the PK
@ 2026-03-16 15:03  Adrian Klaver <[email protected]>
  parent: Igor Korot <[email protected]>
  1 sibling, 2 replies; 8+ messages in thread

From: Adrian Klaver @ 2026-03-16 15:03 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; +Cc: David G. Johnston <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>

On 3/15/26 6:23 PM, Igor Korot wrote:
> Hi, Adrian,
> 
> Here is the log file from running in ODBC mode: https://bpa.st/Z2DWG

I have no idea what this is trying to show?

Is it referring to the thread  I linked to below:

"CREATE TABLE fails"

or this thread?

In any case what actions on the client action where done and how did 
they not match expectations?

If this was really about the "CREATE TABLE fails" thread it needs to go 
back there.

As to this thread go back to:

https://www.postgresql.org/message-id/3547f40b-08b9-4d0c-bba8-f1c26d0bf09d%40aklaver.com

and provide the information requested.

> 
> Thank you.
> 
> On Sun, Mar 15, 2026 at 10:34 AM Adrian Klaver
> <[email protected]> wrote:
>>
>> On 3/14/26 11:24 PM, Igor Korot wrote:
>>> Hi, Adrian,
>>
>>>
>>> Lets start with the beginning:
>>>
>>> draft=# CREATE TABLE leagues_new(id serial, name varchar(100),
>>> drafttype smallint, scoringtype smallint, roundvalues smallint,
>>> leaguetype char(5), salary integer, benchplayers smallint, primary
>>> key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50,
>>> deduplicate_items = OFF ));
>>> CREATE TABLE
>>> draft=#
>>
>> I think the above is for this thread:
>>
>> https://www.postgresql.org/message-id/CA%2BFnnTyGEM-1mwxKPbwFTOodf%2BYUX%3DTxTmBPY5S%3DYh1h%3DoVY9A%...
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> [email protected]


-- 
Adrian Klaver
[email protected]






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Does included columns part of the PK
@ 2026-03-16 18:43  Igor Korot <[email protected]>
  parent: Greg Sabino Mullane <[email protected]>
  0 siblings, 0 replies; 8+ messages in thread

From: Igor Korot @ 2026-03-16 18:43 UTC (permalink / raw)
  To: Greg Sabino Mullane <[email protected]>; +Cc: Adrian Klaver <[email protected]>; David G. Johnston <[email protected]>; pgsql-generallists.postgresql.org <[email protected]>

Thx, Greg.


On Mon, Mar 16, 2026, 6:53 AM Greg Sabino Mullane <[email protected]>
wrote:

> Please don't send links to external sites. Since I've already clicked on
> it, I'll put it here for the archives as an attachment.
>
>
>


^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Does included columns part of the PK
@ 2026-03-16 21:27  Adrian Klaver <[email protected]>
  parent: Adrian Klaver <[email protected]>
  1 sibling, 0 replies; 8+ messages in thread

From: Adrian Klaver @ 2026-03-16 21:27 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; +Cc: pgsql-general

On 3/16/26 11:44 AM, Igor Korot wrote:
Reply to list also
Ccing list
> Adrian,
> 
> On Mon, Mar 16, 2026, 8:03 AM Adrian Klaver <[email protected] 
> <mailto:[email protected]>> wrote:
> 
>     On 3/15/26 6:23 PM, Igor Korot wrote:
>      > Hi, Adrian,
>      >
>      > Here is the log file from running in ODBC mode: https://bpa.st/
>     Z2DWG <https://bpa.st/Z2DWG;
> 
>     I have no idea what this is trying to show?
> 
> 
> Didn't you ask for a log file from running ODBC?

No.

 From here:

https://www.postgresql.org/message-id/3547f40b-08b9-4d0c-bba8-f1c26d0bf09d%40aklaver.com

"
So how are using it in your code and what are the actual results?


Also what is showing up in the Postgres logs?
"

While you are it specify what ODBC driver you are using and what what 
version.

> 
> Thank you.

-- 
Adrian Klaver
[email protected]






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Does included columns part of the PK
@ 2026-03-16 21:30  Adrian Klaver <[email protected]>
  parent: Adrian Klaver <[email protected]>
  1 sibling, 1 reply; 8+ messages in thread

From: Adrian Klaver @ 2026-03-16 21:30 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; +Cc: pgsql-general

On 3/16/26 11:47 AM, Igor Korot wrote:

Reply to list also.
Ccing list.
> Adrian,
> 
> 
> 
> On Mon, Mar 16, 2026, 8:03 AM Adrian Klaver <[email protected] 
> <mailto:[email protected]>> wrote:
> 
>     On 3/15/26 6:23 PM, Igor Korot wrote:
>      > Hi, Adrian,
>      >
>      > Here is the log file from running in ODBC mode: https://bpa.st/
>     Z2DWG <https://bpa.st/Z2DWG;
> 
>     I have no idea what this is trying to show?
> 
> 
> The log shows ODBC connection and then at the end - call to 
> SQLPrimaryKeys().

Where?

I don't see that in either the link you posted or the text file Greg 
sent to the list.

> 
> If you run it against the table I posted above, you will get 3 fields.  
> Whereas it should be just one.

Again, run it how?

> 
> Thank you.
> 
-- 
Adrian Klaver
[email protected]






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Does included columns part of the PK
@ 2026-03-16 21:40  Adrian Klaver <[email protected]>
  parent: Adrian Klaver <[email protected]>
  0 siblings, 0 replies; 8+ messages in thread

From: Adrian Klaver @ 2026-03-16 21:40 UTC (permalink / raw)
  To: Igor Korot <[email protected]>; +Cc: pgsql-general

On 3/16/26 2:30 PM, Adrian Klaver wrote:
> On 3/16/26 11:47 AM, Igor Korot wrote:
> 
> Reply to list also.
> Ccing list.
>> Adrian,
>>
>>
>>
>> On Mon, Mar 16, 2026, 8:03 AM Adrian Klaver <[email protected] 
>> <mailto:[email protected]>> wrote:
>>
>>     On 3/15/26 6:23 PM, Igor Korot wrote:
>>      > Hi, Adrian,
>>      >
>>      > Here is the log file from running in ODBC mode: https://bpa.st/
>>     Z2DWG <https://bpa.st/Z2DWG;
>>
>>     I have no idea what this is trying to show?
>>
>>
>> The log shows ODBC connection and then at the end - call to 
>> SQLPrimaryKeys().
> 
> Where?
> 
> I don't see that in either the link you posted or the text file Greg 
> sent to the list.
> 
>>
>> If you run it against the table I posted above, you will get 3 fields. 
>> Whereas it should be just one.
> 
> Again, run it how?

Alright I see what you are talking about now. I'm not using the ODBC 
driver just it's query. In psql :

CREATE TABLE leagues_new (
     id serial,
     name varchar(100),
     drafttype smallint,
     scoringtype smallint,
     roundvalues smallint,
     leaguetype char(5),
     salary integer,
     benchplayers smallint,
     PRIMARY KEY (id) INCLUDE (drafttype, scoringtype
) WITH (fillfactor = 50, deduplicate_items = OFF)
);


SELECT
     ta.attname,
     ia.attnum,
     ic.relname,
     n.nspname,
     tc.relname
FROM
     pg_catalog.pg_attribute ta,
     pg_catalog.pg_attribute ia,
     pg_catalog.pg_class tc,
     pg_catalog.pg_index i,
     pg_catalog.pg_namespace n,
     pg_catalog.pg_class ic
WHERE
     tc.relname = 'leagues_new'
     AND n.nspname = 'public'
     AND tc.oid = i.indrelid
     AND n.oid = tc.relnamespace
     AND i.indisprimary = 't'
     AND ia.attrelid = i.indexrelid
     AND ta.attrelid = i.indrelid
     AND ta.attnum = i.indkey[ia.attnum - 1]
     AND (NOT ta.attisdropped)
     AND (NOT ia.attisdropped)
     AND ic.oid = i.indexrelid
ORDER BY
     ia.attnum;

yields

attname   | attnum |     relname      | nspname |   relname
-------------+--------+------------------+---------+-------------
  id          |      1 | leagues_new_pkey | public  | leagues_new
  drafttype   |      2 | leagues_new_pkey | public  | leagues_new
  scoringtype |      3 | leagues_new_pkey | public  | leagues_new


> 
>>
>> Thank you.
>>


-- 
Adrian Klaver
[email protected]






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

end of thread, other threads:[~2026-03-16 21:40 UTC | newest]

Thread overview: 8+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-03-15 15:34 Re: Does included columns part of the PK Adrian Klaver <[email protected]>
2026-03-16 01:23 ` Igor Korot <[email protected]>
2026-03-16 13:53   ` Greg Sabino Mullane <[email protected]>
2026-03-16 18:43     ` Igor Korot <[email protected]>
2026-03-16 15:03   ` Adrian Klaver <[email protected]>
2026-03-16 21:27     ` Adrian Klaver <[email protected]>
2026-03-16 21:30     ` Adrian Klaver <[email protected]>
2026-03-16 21:40       ` Adrian Klaver <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox