MIME-Version: 1.0
References: 
 <CA+FnnTz7+dbyk5Gn2iM-eo1Xvfax15yjBevmCCfvo0-UVW1K7Q@mail.gmail.com>
 <b3f6ecfb-8772-4e15-a772-8e64fb573d49@aklaver.com>
 <CAKFQuwYswndGOm6vnsoNSTWHEC5d29bvYokymtDEY_cyW54FEQ@mail.gmail.com>
 <CA+FnnTyFVn4Ebx9kP-5vooZwpATwV5Euc8Nt6TGmEuR6oDYd9A@mail.gmail.com>
 <3547f40b-08b9-4d0c-bba8-f1c26d0bf09d@aklaver.com>
In-Reply-To: <3547f40b-08b9-4d0c-bba8-f1c26d0bf09d@aklaver.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sun, 15 Mar 2026 01:24:38 -0500
Message-ID: 
 <CA+FnnTwLvp1wweqWJkw1+sg4x+pM_oGVmfc-3TaPpE_557=A_A@mail.gmail.com>
Subject: Re: Does included columns part of the PK
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>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTwLvp1wweqWJkw1%2Bsg4x%2BpM_oGVmfc-3TaPpE_557%3DA_A%40mail.gmail.com>
Precedence: bulk

Hi, Adrian,

On Sat, Mar 14, 2026 at 6:30=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com> wrote:
>
> On 3/14/26 9:56 AM, Igor Korot wrote:
> > Hi,
> >
> > On Sat, Mar 14, 2026 at 8:51=E2=80=AFAM 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>> wrot=
e:
> >
> >         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 =E2=80=9Cthey=E2=80=9D - =E2=80=9CHe=E2=80=9D. =F0=9F=98=8A
> >
> > And yes - that=E2=80=99s what I=E2=80=99m referring to.
>
>  From here:
>
>
> https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=3Dfunctions-sqlprima=
rykeys-get-primary-key-columns-table:
>
> 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 tab=
le.
> 4       COLUMN_NAME     VARCHAR(128) NOT NULL   Primary key column name.
> 5       KEY_SEQ SMALLINT NOT NULL       Column sequence number in the pri=
mary key,
> starting with 1.
> 6       PK_NAME VARCHAR(128)    Primary key identifier. Contains a null v=
alue if
> not applicable to the data
>
>

Lets start with the beginning:

draft=3D# 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 =3D 50,
deduplicate_items =3D OFF ));
CREATE TABLE
draft=3D#


>  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 To=
m 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 =3D column_name
> attnum =3D key_seq
> ic.relname =3D pk_name
> nspname =3D table_schem
> tc.relname =3D 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