MIME-Version: 1.0
References: 
 <CA+FnnTy+Q9D9yrB+_qWP9yMweYxJe35LwWmp1eZAEviK9Uwpdg@mail.gmail.com>
 <CADK3HHJVyRMc0Tfbd2Z8SuM6q0R0t125AiV5g=+iHejgkWrL4Q@mail.gmail.com>
In-Reply-To: 
 <CADK3HHJVyRMc0Tfbd2Z8SuM6q0R0t125AiV5g=+iHejgkWrL4Q@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sun, 29 Mar 2026 08:34:38 -0700
Message-ID: 
 <CA+FnnTzGwOiVN1CiRUtQr-joCJJhC7XtZ-4XUSk_MV+ZbcH+Rw@mail.gmail.com>
Subject: Re: Included fields should not be a part of SQLPrimaryKey()
To: Dave Cramer <davecramer@gmail.com>
Cc: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008bbfba064e2b79a4"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTzGwOiVN1CiRUtQr-joCJJhC7XtZ-4XUSk_MV%2BZbcH%2BRw%40mail.gmail.com>
Precedence: bulk

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

Hi, Dave,


On Sun, Mar 29, 2026 at 4:41=E2=80=AFAM Dave Cramer <davecramer@gmail.com> =
wrote:

> Hi Igor,
>
> Are you saying that the rest of the columns in the table should not be
> returned ?
>

If I have PRIMARY KEY with INCLUDED clause, only PK fields should be
returned.


> What version of the ODBC driver are you using?
>

On Windows I=E2=80=99m using the latest driver.
On Linux slightly older.

Thank you.


> Dave Cramer
>
>
> On Sat, 28 Mar 2026 at 23:17, Igor Korot <ikorot01@gmail.com> wrote:
>
>> Hi, list,
>>
>> In my experience with PostgreSQL on either Linux or Windows
>> the included fields are returned as part of the call to SQLPrimaryKey.
>>
>> I already sent an E-mail to this list about it but seeing that there is
>> no response, I am trying again.
>>
>> Thank you.
>>
>>
>>

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

<div dir=3D"auto">Hi, Dave,</div><div dir=3D"auto"><br></div><div><br><div =
class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail=
_attr">On Sun, Mar 29, 2026 at 4:41=E2=80=AFAM Dave Cramer &lt;<a href=3D"m=
ailto:davecramer@gmail.com">davecramer@gmail.com</a>&gt; wrote:<br></div><b=
lockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px =
#ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>Hi Igor,</div><div><br><=
/div><div>Are you saying that the rest of the columns in=C2=A0the table sho=
uld not be returned ?</div></div></blockquote><div dir=3D"auto"><br></div><=
div dir=3D"auto">If I have PRIMARY KEY with INCLUDED clause, only PK fields=
 should be returned.</div><div dir=3D"auto"><br></div><div dir=3D"auto"><br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-=
left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"auto"></=
div><div><br></div><div>What version of the ODBC driver are you using?</div=
></div></blockquote><div dir=3D"auto"><br></div><div dir=3D"auto">On Window=
s I=E2=80=99m using the latest driver.</div><div dir=3D"auto">On Linux slig=
htly older.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thank you.</=
div><div dir=3D"auto"><br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"=
ltr"><div dir=3D"auto"></div></div><div dir=3D"ltr"><div><br></div><div><di=
v dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature">=
Dave Cramer</div></div><br></div><br><div class=3D"gmail_quote"><div dir=3D=
"ltr" class=3D"gmail_attr">On Sat, 28 Mar 2026 at 23:17, Igor Korot &lt;<a =
href=3D"mailto:ikorot01@gmail.com" target=3D"_blank">ikorot01@gmail.com</a>=
&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi, =
list,<br>
<br>
In my experience with PostgreSQL on either Linux or Windows<br>
the included fields are returned as part of the call to SQLPrimaryKey.<br>
<br>
I already sent an E-mail to this list about it but seeing that there is<br>
no response, I am trying again.<br>
<br>
Thank you.<br>
<br>
<br>
</blockquote></div>
</blockquote></div></div>

--0000000000008bbfba064e2b79a4--