Re: Included fields should not be a part of SQLPrimaryKey() - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: Included fields should not be a part of SQLPrimaryKey()
Date
Msg-id CADK3HHLesAVAONaE+pRtYa3s0rUqNAi_ZWA8H5dSWjHXH5dRsg@mail.gmail.com
Whole thread Raw
In response to Re: Included fields should not be a part of SQLPrimaryKey()  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Included fields should not be a part of SQLPrimaryKey()
List pgsql-odbc
Hi Igor,

Dave Cramer


On Tue, 31 Mar 2026 at 20:42, Igor Korot <ikorot01@gmail.com> wrote:
Ping…

On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <ikorot01@gmail.com> wrote:
Dave,

On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <ikorot01@gmail.com> wrote:
>
> Hi, Dave,
>
>
> On Sun, Mar 29, 2026 at 4:41 AM 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’m 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="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.
>>>
>>>

pgsql-odbc by date:

Previous
From: Igor Korot
Date:
Subject: Re: Included fields should not be a part of SQLPrimaryKey()
Next
From: Igor Korot
Date:
Subject: Re: Included fields should not be a part of SQLPrimaryKey()