MIME-Version: 1.0
In-Reply-To: <b3f6ecfb-8772-4e15-a772-8e64fb573d49@aklaver.com>
References: 
 <CA+FnnTz7+dbyk5Gn2iM-eo1Xvfax15yjBevmCCfvo0-UVW1K7Q@mail.gmail.com>
 <b3f6ecfb-8772-4e15-a772-8e64fb573d49@aklaver.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 14 Mar 2026 08:51:24 -0700
Message-ID: 
 <CAKFQuwYswndGOm6vnsoNSTWHEC5d29bvYokymtDEY_cyW54FEQ@mail.gmail.com>
Subject: Re: Does included columns part of the PK
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Igor Korot <ikorot01@gmail.com>,
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000050583e064cfdf56b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwYswndGOm6vnsoNSTWHEC5d29bvYokymtDEY_cyW54FEQ%40mail.gmail.com>
Precedence: bulk

--00000000000050583e064cfdf56b
Content-Type: text/plain; charset="UTF-8"

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.

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

On Saturday, March 14, 2026, Adrian Klaver &lt;<a href=3D"mailto:adrian.kla=
ver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; wrote:<br><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-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><div><br></div><div>David J.=C2=A0</div>

--00000000000050583e064cfdf56b--