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>
In-Reply-To: 
 <CA+FnnTzGwOiVN1CiRUtQr-joCJJhC7XtZ-4XUSk_MV+ZbcH+Rw@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sun, 29 Mar 2026 19:20:59 -0500
Message-ID: 
 <CA+FnnTyRcGw6jgzchW7gmKOfXdQaTTP55YnyFpyKRvEyGHVkgQ@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: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTyRcGw6jgzchW7gmKOfXdQaTTP55YnyFpyKRvEyGHVkgQ%40mail.gmail.com>
Precedence: bulk

Dave,

On Sun, Mar 29, 2026 at 10:34=E2=80=AFAM Igor Korot <ikorot01@gmail.com> wr=
ote:
>
> 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 r=
eturned ?
>
>
> If I have PRIMARY KEY with INCLUDED clause, only PK fields should be retu=
rned.
>
>
>>
>> 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.
>>>
>>>