public inbox for pgsql-odbc@postgresql.org
help / color / mirror / Atom feedIncluded fields should not be a part of SQLPrimaryKey()
9+ messages / 2 participants
[nested] [flat]
* Included fields should not be a part of SQLPrimaryKey()
@ 2026-03-29 03:17 Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Igor Korot @ 2026-03-29 03:17 UTC (permalink / raw)
To: pgsql-odbc
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.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-03-29 11:41 Dave Cramer <davecramer@gmail.com>
parent: Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Dave Cramer @ 2026-03-29 11:41 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-odbc
Hi Igor,
Are you saying that the rest of the columns in the table should not be
returned ?
What version of the ODBC driver are you using?
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.
>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-03-29 15:34 Igor Korot <ikorot01@gmail.com>
parent: Dave Cramer <davecramer@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Igor Korot @ 2026-03-29 15:34 UTC (permalink / raw)
To: Dave Cramer <davecramer@gmail.com>; +Cc: pgsql-odbc
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.
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.
>>
>>
>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-03-30 00:20 Igor Korot <ikorot01@gmail.com>
parent: Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Igor Korot @ 2026-03-30 00:20 UTC (permalink / raw)
To: Dave Cramer <davecramer@gmail.com>; +Cc: pgsql-odbc
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.
>>>
>>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-04-01 00:42 Igor Korot <ikorot01@gmail.com>
parent: Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Igor Korot @ 2026-04-01 00:42 UTC (permalink / raw)
To: Dave Cramer <davecramer@gmail.com>; +Cc: pgsql-odbc
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.
> >>>
> >>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-04-01 09:24 Dave Cramer <davecramer@gmail.com>
parent: Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Dave Cramer @ 2026-04-01 09:24 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: 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@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.
>> >>>
>> >>>
>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-04-03 01:06 Igor Korot <ikorot01@gmail.com>
parent: Dave Cramer <davecramer@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Igor Korot @ 2026-04-03 01:06 UTC (permalink / raw)
To: Dave Cramer <davecramer@gmail.com>; +Cc: pgsql-odbc
Dave,
On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <davecramer@gmail.com> wrote:
>
> Hi Igor,
>
> Best to create an issue here https://github.com/postgresql-interfaces/psqlodbc/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…
>>
>> 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.
>>> >>>
>>> >>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-04-10 18:45 Igor Korot <ikorot01@gmail.com>
parent: Igor Korot <ikorot01@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Igor Korot @ 2026-04-10 18:45 UTC (permalink / raw)
To: Dave Cramer <davecramer@gmail.com>; +Cc: pgsql-odbc
Ping.
Did anybody look into this?
Thank you.
On Thu, Apr 2, 2026 at 6:06 PM Igor Korot <ikorot01@gmail.com> wrote:
> Dave,
>
> On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <davecramer@gmail.com> wrote:
> >
> > Hi Igor,
> >
> > Best to create an issue here
> https://github.com/postgresql-interfaces/psqlodbc/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…
> >>
> >> 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.
> >>> >>>
> >>> >>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Included fields should not be a part of SQLPrimaryKey()
@ 2026-04-11 08:58 Dave Cramer <davecramer@gmail.com>
parent: Igor Korot <ikorot01@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Dave Cramer @ 2026-04-11 08:58 UTC (permalink / raw)
To: Igor Korot <ikorot01@gmail.com>; +Cc: pgsql-odbc
I haven't had a chance.
I'll see what I can do this week
Dave Cramer
On Fri, 10 Apr 2026 at 14:45, Igor Korot <ikorot01@gmail.com> wrote:
> Ping.
>
> Did anybody look into this?
>
> Thank you.
>
>
> On Thu, Apr 2, 2026 at 6:06 PM Igor Korot <ikorot01@gmail.com> wrote:
>
>> Dave,
>>
>> On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <davecramer@gmail.com> wrote:
>> >
>> > Hi Igor,
>> >
>> > Best to create an issue here
>> https://github.com/postgresql-interfaces/psqlodbc/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…
>> >>
>> >> 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.
>> >>> >>>
>> >>> >>>
>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2026-04-11 08:58 UTC | newest]
Thread overview: 9+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-03-29 03:17 Included fields should not be a part of SQLPrimaryKey() Igor Korot <ikorot01@gmail.com>
2026-03-29 11:41 ` Dave Cramer <davecramer@gmail.com>
2026-03-29 15:34 ` Igor Korot <ikorot01@gmail.com>
2026-03-30 00:20 ` Igor Korot <ikorot01@gmail.com>
2026-04-01 00:42 ` Igor Korot <ikorot01@gmail.com>
2026-04-01 09:24 ` Dave Cramer <davecramer@gmail.com>
2026-04-03 01:06 ` Igor Korot <ikorot01@gmail.com>
2026-04-10 18:45 ` Igor Korot <ikorot01@gmail.com>
2026-04-11 08:58 ` Dave Cramer <davecramer@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox