MIME-Version: 1.0
References: 
 <CA+FnnTy+Q9D9yrB+_qWP9yMweYxJe35LwWmp1eZAEviK9Uwpdg@mail.gmail.com>
 <CADK3HHJVyRMc0Tfbd2Z8SuM6q0R0t125AiV5g=+iHejgkWrL4Q@mail.gmail.com>
 <CA+FnnTzGwOiVN1CiRUtQr-joCJJhC7XtZ-4XUSk_MV+ZbcH+Rw@mail.gmail.com>
 <CA+FnnTyRcGw6jgzchW7gmKOfXdQaTTP55YnyFpyKRvEyGHVkgQ@mail.gmail.com>
In-Reply-To: 
 <CA+FnnTyRcGw6jgzchW7gmKOfXdQaTTP55YnyFpyKRvEyGHVkgQ@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Tue, 31 Mar 2026 17:42:34 -0700
Message-ID: 
 <CA+FnnTycfaxLp6zjZMmr_tNti5esCxtXobjhBMdrHXnyFoHTRg@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="000000000000ca52b0064e5b5c3e"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTycfaxLp6zjZMmr_tNti5esCxtXobjhBMdrHXnyFoHTRg%40mail.gmail.com>
Precedence: bulk

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

Ping=E2=80=A6

On Sun, Mar 29, 2026 at 5:20=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wro=
te:

> Dave,
>
> On Sun, Mar 29, 2026 at 10:34=E2=80=AFAM Igor Korot <ikorot01@gmail.com> =
wrote:
> >
> > Hi, Dave,
> >
> >
> > On Sun, Mar 29, 2026 at 4:41=E2=80=AFAM Dave Cramer <davecramer@gmail.c=
om>
> 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.
>
> Linux version below:
>
> igor@WaylandGnome ~/dbhandler/Debug $ emerge -pv psqlodbc
>  * Last emerge --sync was 2y 5d 20h 34m 44s ago.
>
> These are the packages that would be merged, in order:
>
> Calculating dependencies... done!
> Dependency resolution took 43.43 s (backtrack: 0/20).
>
> [ebuild   R    ] dev-db/psqlodbc-11.01.0000::gentoo  USE=3D"ssl -doc
> -iodbc -threads" 0 KiB
>
> Total: 1 package (1 reinstall), Size of downloads: 0 KiB
> igor@WaylandGnome ~/dbhandler/Debug $
>
> Thank you.
>
> >
> > 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.
> >>>
> >>>
>

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

<div dir=3D"auto">Ping=E2=80=A6</div><div><br><div class=3D"gmail_quote gma=
il_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, Mar 29, 2=
026 at 5:20=E2=80=AFPM Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.com"=
>ikorot01@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">=
Dave,<br>
<br>
On Sun, Mar 29, 2026 at 10:34=E2=80=AFAM Igor Korot &lt;<a href=3D"mailto:i=
korot01@gmail.com" target=3D"_blank">ikorot01@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; Hi, Dave,<br>
&gt;<br>
&gt;<br>
&gt; On Sun, Mar 29, 2026 at 4:41=E2=80=AFAM Dave Cramer &lt;<a href=3D"mai=
lto:davecramer@gmail.com" target=3D"_blank">davecramer@gmail.com</a>&gt; wr=
ote:<br>
&gt;&gt;<br>
&gt;&gt; Hi Igor,<br>
&gt;&gt;<br>
&gt;&gt; Are you saying that the rest of the columns in the table should no=
t be returned ?<br>
&gt;<br>
&gt;<br>
&gt; If I have PRIMARY KEY with INCLUDED clause, only PK fields should be r=
eturned.<br>
&gt;<br>
&gt;<br>
&gt;&gt;<br>
&gt;&gt; What version of the ODBC driver are you using?<br>
&gt;<br>
&gt;<br>
&gt; On Windows I=E2=80=99m using the latest driver.<br>
&gt; On Linux slightly older.<br>
<br>
Linux version below:<br>
<br>
igor@WaylandGnome ~/dbhandler/Debug $ emerge -pv psqlodbc<br>
=C2=A0* Last emerge --sync was 2y 5d 20h 34m 44s ago.<br>
<br>
These are the packages that would be merged, in order:<br>
<br>
Calculating dependencies... done!<br>
Dependency resolution took 43.43 s (backtrack: 0/20).<br>
<br>
[ebuild=C2=A0 =C2=A0R=C2=A0 =C2=A0 ] dev-db/psqlodbc-11.01.0000::gentoo=C2=
=A0 USE=3D&quot;ssl -doc<br>
-iodbc -threads&quot; 0 KiB<br>
<br>
Total: 1 package (1 reinstall), Size of downloads: 0 KiB<br>
igor@WaylandGnome ~/dbhandler/Debug $<br>
<br>
Thank you.<br>
<br>
&gt;<br>
&gt; Thank you.<br>
&gt;<br>
&gt;&gt;<br>
&gt;&gt; Dave Cramer<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; On Sat, 28 Mar 2026 at 23:17, Igor Korot &lt;<a href=3D"mailto:iko=
rot01@gmail.com" target=3D"_blank">ikorot01@gmail.com</a>&gt; wrote:<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; Hi, list,<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; In my experience with PostgreSQL on either Linux or Windows<br=
>
&gt;&gt;&gt; the included fields are returned as part of the call to SQLPri=
maryKey.<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; I already sent an E-mail to this list about it but seeing that=
 there is<br>
&gt;&gt;&gt; no response, I am trying again.<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; Thank you.<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt;<br>
</blockquote></div></div>

--000000000000ca52b0064e5b5c3e--