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>
In-Reply-To: 
 <CAKFQuwYswndGOm6vnsoNSTWHEC5d29bvYokymtDEY_cyW54FEQ@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 14 Mar 2026 09:56:55 -0700
Message-ID: 
 <CA+FnnTyFVn4Ebx9kP-5vooZwpATwV5Euc8Nt6TGmEuR6oDYd9A@mail.gmail.com>
Subject: Re: Does included columns part of the PK
To: "David G. Johnston" <david.g.johnston@gmail.com>,
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000028c061064cfee002"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTyFVn4Ebx9kP-5vooZwpATwV5Euc8Nt6TGmEuR6oDYd9A%40mail.gmail.com>
Precedence: bulk

--00000000000028c061064cfee002
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

On Sat, Mar 14, 2026 at 8:51=E2=80=AFAM 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 =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.

Thank you.


> David J.
>

--00000000000028c061064cfee002
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi,</div><div><br><div class=3D"gmail_quote gmail_quote_c=
ontainer"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Mar 14, 2026 at 8:5=
1=E2=80=AFAM David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail=
.com">david.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">On Saturday, March 14, 2026, Adrian Klaver &lt;<a href=3D"mai=
lto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com<=
/a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .=
8ex;border-left:1px #ccc solid;padding-left:1ex">On 3/14/26 12:09 AM, Igor =
Korot wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
Hi, ALL,<br>
Have one weird question ;-)<br>
<br>
When I connect with ODBC and call SQLPrimaryKey() the function returns<br>
</blockquote>
<br>
Are you actually using the SQLPrimaryKeys(), not SQLPrimaryKey()?<br>
<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
all fields including<br>
&quot;included&quot; fields.<br>
</blockquote>
<br>
Define &#39;included&#39; fields.<br>
</blockquote><div><br></div><div>They are referring to the unique index tha=
t backs the PK constraint.</div></blockquote><div dir=3D"auto"><br></div><d=
iv dir=3D"auto">Not =E2=80=9Cthey=E2=80=9D - =E2=80=9CHe=E2=80=9D. =F0=9F=
=98=8A</div><div dir=3D"auto"><br></div><div dir=3D"auto">And yes - that=E2=
=80=99s what I=E2=80=99m referring to.</div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">Thank you.</div><div dir=3D"auto"><br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex"><div dir=3D"auto"></div><div><br></div><div>David J.=C2=A0</=
div>
</blockquote></div></div>

--00000000000028c061064cfee002--