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

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Included fields should not be a part of SQLPrimaryKey()
Date: 2026-04-01 09:24:17
Message-ID: CADK3HHLesAVAONaE+pRtYa3s0rUqNAi_ZWA8H5dSWjHXH5dRsg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Igor,

Best to create an issue here
https://github.com/postgresql-interfaces/psqlodbc/issues
Dave Cramer

On Tue, 31 Mar 2026 at 20:42, Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> Ping…
>
> On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
>> 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.
>> >>>
>> >>>
>>
>

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-04-03 01:06:55 Re: Included fields should not be a part of SQLPrimaryKey()
Previous Message Igor Korot 2026-04-01 00:42:34 Re: Included fields should not be a part of SQLPrimaryKey()