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>
 <CA+FnnTycfaxLp6zjZMmr_tNti5esCxtXobjhBMdrHXnyFoHTRg@mail.gmail.com>
 <CADK3HHLesAVAONaE+pRtYa3s0rUqNAi_ZWA8H5dSWjHXH5dRsg@mail.gmail.com>
In-Reply-To: 
 <CADK3HHLesAVAONaE+pRtYa3s0rUqNAi_ZWA8H5dSWjHXH5dRsg@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Thu, 2 Apr 2026 18:06:55 -0700
Message-ID: 
 <CA+FnnTzQ6Q=CduRuPDUVq_Ck8xfmsgsY7pHU=7QEAH78qz_E=w@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%2BFnnTzQ6Q%3DCduRuPDUVq_Ck8xfmsgsY7pHU%3D7QEAH78qz_E%3Dw%40mail.gmail.com>
Precedence: bulk

Dave,

On Wed, Apr 1, 2026 at 2:24=E2=80=AFAM Dave Cramer <davecramer@gmail.com> w=
rote:
>
> Hi Igor,
>
> Best to create an issue here https://github.com/postgresql-interfaces/psq=
lodbc/issues

Done - https://github.com/postgresql-interfaces/psqlodbc/issues/170.

Thank you.

> Dave Cramer
>
>
> On Tue, 31 Mar 2026 at 20:42, Igor Korot <ikorot01@gmail.com> wrote:
>>
>> Ping=E2=80=A6
>>
>> On Sun, Mar 29, 2026 at 5:20=E2=80=AFPM Igor Korot <ikorot01@gmail.com> =
wrote:
>>>
>>> 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=
.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.
>>>
>>> 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 SQLPrimaryK=
ey.
>>> >>>
>>> >>> I already sent an E-mail to this list about it but seeing that ther=
e is
>>> >>> no response, I am trying again.
>>> >>>
>>> >>> Thank you.
>>> >>>
>>> >>>