Re: Included fields should not be a part of SQLPrimaryKey()

Dave,

On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
> Hi, Dave,
>
>
> On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <davecramer(at)gmail(dot)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(at)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(at)WaylandGnome ~/dbhandler/Debug $

Thank you.

>
> Thank you.
>
>>
>> Dave Cramer
>>
>>
>> On Sat, 28 Mar 2026 at 23:17, Igor Korot <ikorot01(at)gmail(dot)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.
>>>
>>>