public inbox for pgsql-odbc@postgresql.org
help / color / mirror / Atom feedDoes included columns part of the PK
23+ messages / 4 participants
[nested] [flat]
* Does included columns part of the PK
@ 2026-03-14 07:09 Igor Korot <ikorot01@gmail.com>
2026-03-14 07:12 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:07 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 3 replies; 23+ messages in thread
From: Igor Korot @ 2026-03-14 07:09 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi, ALL,
Have one weird question ;-)
When I connect with ODBC and call SQLPrimaryKey() the function returns
all fields including
"included" fields.
However running libpq and trying to get the table info with:
[quote]
L"SELECT DISTINCT column_name, data_type,
character_maximum_length, character_octet_length, numeric_precision,
numeric_precision_radix, numeric_scale, is_nullable, column_default,
CASE WHEN column_name IN (SELECT ccu.column_name FROM
information_schema.constraint_column_usage ccu,
information_schema.table_constraints tc WHERE ccu.constraint_name =
tc.constraint_name AND tc.constraint_type = 'PRIMARY KEY' AND
ccu.table_name = $2) THEN 'YES' ELSE 'NO' END AS is_pk,
ordinal_position FROM information_schema.columns col,
information_schema.table_constraints tc WHERE tc.table_schema =
col.table_schema AND tc.table_name = col.table_name AND
col.table_schema = $1 AND col.table_name = $2 ORDER BY
ordinal_position;";
[/quote]
I'm getting only direct PK fields.
I presume that libpq is correct and the ODBC driver is the one that
needs to be fixed.
Just wanted to ask this list before going to complain to the ODBC list... ;-)
Thank you.
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-14 07:12 ` Igor Korot <ikorot01@gmail.com>
2 siblings, 0 replies; 23+ messages in thread
From: Igor Korot @ 2026-03-14 07:12 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Below is the version info I use on this machine:
Calculating dependencies... done!
Dependency resolution took 53.38 s (backtrack: 0/20).
[ebuild R ] dev-db/postgresql-16.2:16::gentoo USE="icu lz4 nls
pam readline ssl xml zlib zstd -debug -doc -kerberos -ldap -llvm -perl
-python (-selinux) -server* -static-libs -systemd -tcl -uuid"
PYTHON_SINGLE_TARGET="python3_11 -python3_10 -python3_12" 0 KiB
[ebuild R ] dev-db/psqlodbc-11.01.0000::gentoo USE="ssl -doc
-iodbc -threads" 0 KiB
Total: 2 packages (2 reinstalls), Size of downloads: 0 KiB
WaylandGnome /home/igor/dbhandler/Debug #
Thank you.
On Sat, Mar 14, 2026 at 2:09 AM Igor Korot <ikorot01@gmail.com> wrote:
>
> Hi, ALL,
> Have one weird question ;-)
>
> When I connect with ODBC and call SQLPrimaryKey() the function returns
> all fields including
> "included" fields.
>
> However running libpq and trying to get the table info with:
>
> [quote]
> L"SELECT DISTINCT column_name, data_type,
> character_maximum_length, character_octet_length, numeric_precision,
> numeric_precision_radix, numeric_scale, is_nullable, column_default,
> CASE WHEN column_name IN (SELECT ccu.column_name FROM
> information_schema.constraint_column_usage ccu,
> information_schema.table_constraints tc WHERE ccu.constraint_name =
> tc.constraint_name AND tc.constraint_type = 'PRIMARY KEY' AND
> ccu.table_name = $2) THEN 'YES' ELSE 'NO' END AS is_pk,
> ordinal_position FROM information_schema.columns col,
> information_schema.table_constraints tc WHERE tc.table_schema =
> col.table_schema AND tc.table_name = col.table_name AND
> col.table_schema = $1 AND col.table_name = $2 ORDER BY
> ordinal_position;";
> [/quote]
>
> I'm getting only direct PK fields.
>
> I presume that libpq is correct and the ODBC driver is the one that
> needs to be fixed.
>
> Just wanted to ask this list before going to complain to the ODBC list... ;-)
>
> Thank you.
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-14 15:07 ` David G. Johnston <david.g.johnston@gmail.com>
2 siblings, 0 replies; 23+ messages in thread
From: David G. Johnston @ 2026-03-14 15:07 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
On Saturday, March 14, 2026, Igor Korot <ikorot01@gmail.com> wrote:
>
> I presume that libpq is correct and the ODBC driver is the one that
> needs to be fixed.
>
Odbc does seem to be in the wrong here, yes.
David J.
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-14 15:25 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2 siblings, 1 reply; 23+ messages in thread
From: Adrian Klaver @ 2026-03-14 15:25 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
On 3/14/26 12:09 AM, Igor Korot wrote:
> Hi, ALL,
> Have one weird question ;-)
>
> When I connect with ODBC and call SQLPrimaryKey() the function returns
Are you actually using the SQLPrimaryKeys(), not SQLPrimaryKey()?
> all fields including
> "included" fields.
Define 'included' fields.
> I'm getting only direct PK fields.
Define direct PK fields.
>
> I presume that libpq is correct and the ODBC driver is the one that
> needs to be fixed.
Returning the actual results from each case would help.
Have you cranked up the logging on the Postgres server to see what query
ODBC is using?
>
> Just wanted to ask this list before going to complain to the ODBC list... ;-)
>
> Thank you.
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-14 15:51 ` David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 23+ messages in thread
From: David G. Johnston @ 2026-03-14 15:51 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: Igor Korot <ikorot01@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
On Saturday, March 14, 2026, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
> On 3/14/26 12:09 AM, Igor Korot wrote:
>
>> Hi, ALL,
>> Have one weird question ;-)
>>
>> When I connect with ODBC and call SQLPrimaryKey() the function returns
>>
>
> Are you actually using the SQLPrimaryKeys(), not SQLPrimaryKey()?
>
> all fields including
>> "included" fields.
>>
>
> Define 'included' fields.
>
They are referring to the unique index that backs the PK constraint.
David J.
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
@ 2026-03-14 16:56 ` Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 23+ messages in thread
From: Igor Korot @ 2026-03-14 16:56 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi,
On Sat, Mar 14, 2026 at 8:51 AM David G. Johnston <
david.g.johnston@gmail.com> wrote:
> On Saturday, March 14, 2026, Adrian Klaver <adrian.klaver@aklaver.com>
> wrote:
>
>> On 3/14/26 12:09 AM, Igor Korot wrote:
>>
>>> Hi, ALL,
>>> Have one weird question ;-)
>>>
>>> When I connect with ODBC and call SQLPrimaryKey() the function returns
>>>
>>
>> Are you actually using the SQLPrimaryKeys(), not SQLPrimaryKey()?
>>
>> all fields including
>>> "included" fields.
>>>
>>
>> Define 'included' fields.
>>
>
> They are referring to the unique index that backs the PK constraint.
>
Not “they” - “He”. 😊
And yes - that’s what I’m referring to.
Thank you.
> David J.
>
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-14 23:30 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 23+ messages in thread
From: Adrian Klaver @ 2026-03-14 23:30 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
On 3/14/26 9:56 AM, Igor Korot wrote:
> Hi,
>
> On Sat, Mar 14, 2026 at 8:51 AM David G. Johnston
> <david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:
>
> On Saturday, March 14, 2026, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 3/14/26 12:09 AM, Igor Korot wrote:
>
> Hi, ALL,
> Have one weird question ;-)
>
> When I connect with ODBC and call SQLPrimaryKey() the
> function returns
>
>
> Are you actually using the SQLPrimaryKeys(), not SQLPrimaryKey()?
>
> all fields including
> "included" fields.
>
>
> Define 'included' fields.
>
>
> They are referring to the unique index that backs the PK constraint.
>
>
> Not “they” - “He”. 😊
>
> And yes - that’s what I’m referring to.
From here:
https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=functions-sqlprimarykeys-get-primary-key-column...:
1 TABLE_CAT VARCHAR(128) This is always null.
2 TABLE_SCHEM VARCHAR(128) The name of the schema containing TABLE_NAME.
3 TABLE_NAME VARCHAR(128) NOT NULL Name of the specified table.
4 COLUMN_NAME VARCHAR(128) NOT NULL Primary key column name.
5 KEY_SEQ SMALLINT NOT NULL Column sequence number in the primary key,
starting with 1.
6 PK_NAME VARCHAR(128) Primary key identifier. Contains a null value if
not applicable to the data
From here:
https://github.com/postgresql-interfaces/psqlodbc/blob/main/info.c
At line 4035 in SQLPrimaryKeys()
For case 1
/*
* Simplified query to remove assumptions about number of
* possible index columns. Courtesy of Tom Lane - thomas
* 2000-03-21
*/
[...]
"select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname"
" from pg_catalog.pg_attribute ta ... "
case 2
select ta.attname, ia.attnum, ic.relname, n.nspname, NULL"
" from pg_catalog.pg_attribute ta, ..."
If I am following correctly then:
attname = column_name
attnum = key_seq
ic.relname = pk_name
nspname = table_schem
tc.relname = table_name
So how are using it in your code and what are the actual results?
Also what is showing up in the Postgres logs?
>
> Thank you.
>
>
> David J.
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-15 06:24 ` Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 23+ messages in thread
From: Igor Korot @ 2026-03-15 06:24 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Hi, Adrian,
On Sat, Mar 14, 2026 at 6:30 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 3/14/26 9:56 AM, Igor Korot wrote:
> > Hi,
> >
> > On Sat, Mar 14, 2026 at 8:51 AM David G. Johnston
> > <david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:
> >
> > On Saturday, March 14, 2026, Adrian Klaver
> > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
> >
> > On 3/14/26 12:09 AM, Igor Korot wrote:
> >
> > Hi, ALL,
> > Have one weird question ;-)
> >
> > When I connect with ODBC and call SQLPrimaryKey() the
> > function returns
> >
> >
> > Are you actually using the SQLPrimaryKeys(), not SQLPrimaryKey()?
> >
> > all fields including
> > "included" fields.
> >
> >
> > Define 'included' fields.
> >
> >
> > They are referring to the unique index that backs the PK constraint.
> >
> >
> > Not “they” - “He”. 😊
> >
> > And yes - that’s what I’m referring to.
>
> From here:
>
>
> https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=functions-sqlprimarykeys-get-primary-key-column...:
>
> 1 TABLE_CAT VARCHAR(128) This is always null.
> 2 TABLE_SCHEM VARCHAR(128) The name of the schema containing TABLE_NAME.
> 3 TABLE_NAME VARCHAR(128) NOT NULL Name of the specified table.
> 4 COLUMN_NAME VARCHAR(128) NOT NULL Primary key column name.
> 5 KEY_SEQ SMALLINT NOT NULL Column sequence number in the primary key,
> starting with 1.
> 6 PK_NAME VARCHAR(128) Primary key identifier. Contains a null value if
> not applicable to the data
>
>
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=#
> From here:
>
> https://github.com/postgresql-interfaces/psqlodbc/blob/main/info.c
>
> At line 4035 in SQLPrimaryKeys()
>
> For case 1
>
> /*
> * Simplified query to remove assumptions about number of
> * possible index columns. Courtesy of Tom Lane - thomas
> * 2000-03-21
> */
>
> [...]
>
> "select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname"
> " from pg_catalog.pg_attribute ta ... "
>
>
> case 2
>
> select ta.attname, ia.attnum, ic.relname, n.nspname, NULL"
> " from pg_catalog.pg_attribute ta, ..."
>
> If I am following correctly then:
>
> attname = column_name
> attnum = key_seq
> ic.relname = pk_name
> nspname = table_schem
> tc.relname = table_name
>
>
> So how are using it in your code and what are the actual results?
>
> Also what is showing up in the Postgres logs?
>
> >
> > Thank you.
> >
> >
> > David J.
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-15 15:34 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 23+ messages in thread
From: Adrian Klaver @ 2026-03-15 15:34 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-16 01:23 ` Igor Korot <ikorot01@gmail.com>
2026-03-16 13:53 ` Re: Does included columns part of the PK Greg Sabino Mullane <htamfids@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 2 replies; 23+ messages in thread
From: Igor Korot @ 2026-03-16 01:23 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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
<adrian.klaver@aklaver.com> 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
> adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-16 13:53 ` Greg Sabino Mullane <htamfids@gmail.com>
2026-03-16 18:43 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
1 sibling, 1 reply; 23+ messages in thread
From: Greg Sabino Mullane @ 2026-03-16 13:53 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 13:53 ` Re: Does included columns part of the PK Greg Sabino Mullane <htamfids@gmail.com>
@ 2026-03-16 18:43 ` Igor Korot <ikorot01@gmail.com>
0 siblings, 0 replies; 23+ messages in thread
From: Igor Korot @ 2026-03-16 18:43 UTC (permalink / raw)
To: Greg Sabino Mullane <htamfids@gmail.com>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Thx, Greg.
On Mon, Mar 16, 2026, 6:53 AM Greg Sabino Mullane <htamfids@gmail.com>
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] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-16 15:03 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:27 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
1 sibling, 2 replies; 23+ messages in thread
From: Adrian Klaver @ 2026-03-16 15:03 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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
> <adrian.klaver@aklaver.com> 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
>> adrian.klaver@aklaver.com
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-16 21:27 ` Adrian Klaver <adrian.klaver@aklaver.com>
1 sibling, 0 replies; 23+ messages in thread
From: Adrian Klaver @ 2026-03-16 21:27 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
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 <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> 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
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-16 21:30 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
1 sibling, 1 reply; 23+ messages in thread
From: Adrian Klaver @ 2026-03-16 21:30 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
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 <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> 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
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-16 21:40 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 23+ messages in thread
From: Adrian Klaver @ 2026-03-16 21:40 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
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 <adrian.klaver@aklaver.com
>> <mailto:adrian.klaver@aklaver.com>> 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
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-16 21:51 ` Igor Korot <ikorot01@gmail.com>
2026-03-16 21:53 ` Fwd: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 21:57 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 2 replies; 23+ messages in thread
From: Igor Korot @ 2026-03-16 21:51 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
Adrian,
On Mon, Mar 16, 2026 at 2:40 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> 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 <adrian.klaver@aklaver.com
> >> <mailto:adrian.klaver@aklaver.com>> 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
Correct.
And according to the second reply it should yeld just the first record.
I'm going to forward this to the ODBC list...
Thank you.
>
>
> >
> >>
> >> Thank you.
> >>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Fwd: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-16 21:53 ` Igor Korot <ikorot01@gmail.com>
1 sibling, 0 replies; 23+ messages in thread
From: Igor Korot @ 2026-03-16 21:53 UTC (permalink / raw)
To: pgsql-odbc
Hi, List.
This is what I found out.
Could someone please look into it?
Thank you.
---------- Forwarded message ---------
From: Igor Korot <ikorot01@gmail.com>
Date: Mon, Mar 16, 2026 at 2:51 PM
Subject: Re: Does included columns part of the PK
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Adrian,
On Mon, Mar 16, 2026 at 2:40 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> 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 <adrian.klaver@aklaver.com
> >> <mailto:adrian.klaver@aklaver.com>> 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
Correct.
And according to the second reply it should yeld just the first record.
I'm going to forward this to the ODBC list...
Thank you.
>
>
> >
> >>
> >> Thank you.
> >>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-16 21:57 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 23:38 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
1 sibling, 1 reply; 23+ messages in thread
From: Adrian Klaver @ 2026-03-16 21:57 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
On 3/16/26 2:51 PM, Igor Korot wrote:
> Adrian,
>
> On Mon, Mar 16, 2026 at 2:40 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> 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 <adrian.klaver@aklaver.com
>>>> <mailto:adrian.klaver@aklaver.com>> 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
>
> Correct.
>
> And according to the second reply it should yeld just the first record.
>
> I'm going to forward this to the ODBC list...
I have not worked it out yet but would start with:
AND ta.attnum = i.indkey[ia.attnum - 1]
per
www.postgresql.org/docs/current/catalog-pg-index.html
"
indkey int2vector (references pg_attribute.attnum)
...
This is an array of indnatts values that indicate which table columns
this index indexes. For example, a value of 1 3 would mean that the
first and the third table columns make up the index entries. Key columns
come before non-key (included) columns.
...
"
Though there is the below from the same page:
"indnatts int2
The total number of columns in the index (duplicates pg_class.relnatts);
this number includes both key and included attributes
indnkeyatts int2
The number of key columns in the index, not counting any included
columns, which are merely stored and do not participate in the index
semantics
"
>
> Thank you.
>
>>
>>
>>>
>>>>
>>>> Thank you.
>>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 21:57 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-16 23:38 ` Igor Korot <ikorot01@gmail.com>
2026-03-17 00:44 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 1 reply; 23+ messages in thread
From: Igor Korot @ 2026-03-16 23:38 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
Adrian,
Most important - do you agree that those fields should not be in this
recordset?
Thank you.
On Mon, Mar 16, 2026 at 2:57 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 3/16/26 2:51 PM, Igor Korot wrote:
> > Adrian,
> >
> > On Mon, Mar 16, 2026 at 2:40 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> >>
> >> 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 <adrian.klaver@aklaver.com
> >>>> <mailto:adrian.klaver@aklaver.com>> 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
> >
> > Correct.
> >
> > And according to the second reply it should yeld just the first record.
> >
> > I'm going to forward this to the ODBC list...
>
> I have not worked it out yet but would start with:
>
> AND ta.attnum = i.indkey[ia.attnum - 1]
>
> per
>
> www.postgresql.org/docs/current/catalog-pg-index.html
>
> "
> indkey int2vector (references pg_attribute.attnum)
>
> ...
>
> This is an array of indnatts values that indicate which table columns
> this index indexes. For example, a value of 1 3 would mean that the
> first and the third table columns make up the index entries. Key columns
> come before non-key (included) columns.
>
> ...
> "
>
> Though there is the below from the same page:
>
> "indnatts int2
>
> The total number of columns in the index (duplicates pg_class.relnatts);
> this number includes both key and included attributes
>
> indnkeyatts int2
>
> The number of key columns in the index, not counting any included
> columns, which are merely stored and do not participate in the index
> semantics
> "
>
>
> >
> > Thank you.
> >
> >>
> >>
> >>>
> >>>>
> >>>> Thank you.
> >>>>
> >>
> >>
> >> --
> >> Adrian Klaver
> >> adrian.klaver@aklaver.com
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 21:57 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 23:38 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-03-17 00:44 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-17 01:11 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 23+ messages in thread
From: Adrian Klaver @ 2026-03-17 00:44 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
On 3/16/26 4:38 PM, Igor Korot wrote:
> Adrian,
>
> Most important - do you agree that those fields should not be in this
> recordset?
I don't see anything here:
https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlprimarykeys-function?view=sql-server-...
that says they should be returned. Though the above also says:
" Additional columns beyond column 6 (PK_NAME) can be defined by the
driver."
That is not the case here, where additional rows are used. However it
does allow for more information to be supplied.
My purely un-expert analysis is, no the extra rows should not be there.
>
> Thank you.
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 21:57 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 23:38 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-17 00:44 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
@ 2026-03-17 01:11 ` Igor Korot <ikorot01@gmail.com>
2026-04-21 05:33 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 23+ messages in thread
From: Igor Korot @ 2026-03-17 01:11 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
Adrian,,
On Mon, Mar 16, 2026 at 5:44 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 3/16/26 4:38 PM, Igor Korot wrote:
> > Adrian,
> >
> > Most important - do you agree that those fields should not be in this
> > recordset?
>
> I don't see anything here:
>
> https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlprimarykeys-function?view=sql-server-...
>
> that says they should be returned. Though the above also says:
>
> " Additional columns beyond column 6 (PK_NAME) can be defined by the
> driver."
>
> That is not the case here, where additional rows are used. However it
> does allow for more information to be supplied.
>
> My purely un-expert analysis is, no the extra rows should not be there.
Thx for confirming.
I already forwarded the email with the query results over to ODBC list.
Hopefully someone can come back soon.
Are you reading that list as well? If not I will update this thread
with the results.
Thank you.
>
> >
> > Thank you.
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
* Re: Does included columns part of the PK
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 15:25 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` Re: Does included columns part of the PK David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-16 21:57 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 23:38 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-17 00:44 ` Re: Does included columns part of the PK Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-17 01:11 ` Re: Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
@ 2026-04-21 05:33 ` Igor Korot <ikorot01@gmail.com>
0 siblings, 0 replies; 23+ messages in thread
From: Igor Korot @ 2026-04-21 05:33 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
For all involved and interested:
The issue with ODBC driver has been fixed and will
be part of the next release.
Ref: https://github.com/postgresql-interfaces/psqlodbc/issues/170.
Thank you.
On Mon, Mar 16, 2026 at 6:11 PM Igor Korot <ikorot01@gmail.com> wrote:
>
> Adrian,,
>
> On Mon, Mar 16, 2026 at 5:44 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> >
> > On 3/16/26 4:38 PM, Igor Korot wrote:
> > > Adrian,
> > >
> > > Most important - do you agree that those fields should not be in this
> > > recordset?
> >
> > I don't see anything here:
> >
> > https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlprimarykeys-function?view=sql-server-...
> >
> > that says they should be returned. Though the above also says:
> >
> > " Additional columns beyond column 6 (PK_NAME) can be defined by the
> > driver."
> >
> > That is not the case here, where additional rows are used. However it
> > does allow for more information to be supplied.
> >
> > My purely un-expert analysis is, no the extra rows should not be there.
>
> Thx for confirming.
>
> I already forwarded the email with the query results over to ODBC list.
>
> Hopefully someone can come back soon.
>
> Are you reading that list as well? If not I will update this thread
> with the results.
>
> Thank you.
>
> >
> > >
> > > Thank you.
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 23+ messages in thread
end of thread, other threads:[~2026-04-21 05:33 UTC | newest]
Thread overview: 23+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-03-14 07:09 Does included columns part of the PK Igor Korot <ikorot01@gmail.com>
2026-03-14 07:12 ` Igor Korot <ikorot01@gmail.com>
2026-03-14 15:07 ` David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 15:25 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-14 15:51 ` David G. Johnston <david.g.johnston@gmail.com>
2026-03-14 16:56 ` Igor Korot <ikorot01@gmail.com>
2026-03-14 23:30 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-15 06:24 ` Igor Korot <ikorot01@gmail.com>
2026-03-15 15:34 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 01:23 ` Igor Korot <ikorot01@gmail.com>
2026-03-16 13:53 ` Greg Sabino Mullane <htamfids@gmail.com>
2026-03-16 18:43 ` Igor Korot <ikorot01@gmail.com>
2026-03-16 15:03 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:27 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:30 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:40 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 21:51 ` Igor Korot <ikorot01@gmail.com>
2026-03-16 21:53 ` Igor Korot <ikorot01@gmail.com>
2026-03-16 21:57 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-16 23:38 ` Igor Korot <ikorot01@gmail.com>
2026-03-17 00:44 ` Adrian Klaver <adrian.klaver@aklaver.com>
2026-03-17 01:11 ` Igor Korot <ikorot01@gmail.com>
2026-04-21 05:33 ` Igor Korot <ikorot01@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox