public inbox for [email protected]help / color / mirror / Atom feed
Included 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 <[email protected]> 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 <[email protected]> parent: Igor Korot <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Dave Cramer @ 2026-03-29 11:41 UTC (permalink / raw) To: Igor Korot <[email protected]>; +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 <[email protected]> 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 <[email protected]> parent: Dave Cramer <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Igor Korot @ 2026-03-29 15:34 UTC (permalink / raw) To: Dave Cramer <[email protected]>; +Cc: pgsql-odbc Hi, Dave, On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <[email protected]> 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 <[email protected]> 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 <[email protected]> parent: Igor Korot <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Igor Korot @ 2026-03-30 00:20 UTC (permalink / raw) To: Dave Cramer <[email protected]>; +Cc: pgsql-odbc Dave, On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <[email protected]> wrote: > > Hi, Dave, > > > On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <[email protected]> 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 <[email protected]> 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 <[email protected]> parent: Igor Korot <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Igor Korot @ 2026-04-01 00:42 UTC (permalink / raw) To: Dave Cramer <[email protected]>; +Cc: pgsql-odbc Ping… On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <[email protected]> wrote: > Dave, > > On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <[email protected]> wrote: > > > > Hi, Dave, > > > > > > On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <[email protected]> > 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 <[email protected]> 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 <[email protected]> parent: Igor Korot <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Dave Cramer @ 2026-04-01 09:24 UTC (permalink / raw) To: Igor Korot <[email protected]>; +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 <[email protected]> wrote: > Ping… > > On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <[email protected]> wrote: > >> Dave, >> >> On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <[email protected]> wrote: >> > >> > Hi, Dave, >> > >> > >> > On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <[email protected]> >> 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 <[email protected]> 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 <[email protected]> parent: Dave Cramer <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Igor Korot @ 2026-04-03 01:06 UTC (permalink / raw) To: Dave Cramer <[email protected]>; +Cc: pgsql-odbc Dave, On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <[email protected]> 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 <[email protected]> wrote: >> >> Ping… >> >> On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <[email protected]> wrote: >>> >>> Dave, >>> >>> On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <[email protected]> wrote: >>> > >>> > Hi, Dave, >>> > >>> > >>> > On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <[email protected]> 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 <[email protected]> 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 <[email protected]> parent: Igor Korot <[email protected]> 0 siblings, 1 reply; 9+ messages in thread From: Igor Korot @ 2026-04-10 18:45 UTC (permalink / raw) To: Dave Cramer <[email protected]>; +Cc: pgsql-odbc Ping. Did anybody look into this? Thank you. On Thu, Apr 2, 2026 at 6:06 PM Igor Korot <[email protected]> wrote: > Dave, > > On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <[email protected]> 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 <[email protected]> wrote: > >> > >> Ping… > >> > >> On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <[email protected]> wrote: > >>> > >>> Dave, > >>> > >>> On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <[email protected]> > wrote: > >>> > > >>> > Hi, Dave, > >>> > > >>> > > >>> > On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <[email protected]> > 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 <[email protected]> > 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 <[email protected]> parent: Igor Korot <[email protected]> 0 siblings, 0 replies; 9+ messages in thread From: Dave Cramer @ 2026-04-11 08:58 UTC (permalink / raw) To: Igor Korot <[email protected]>; +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 <[email protected]> wrote: > Ping. > > Did anybody look into this? > > Thank you. > > > On Thu, Apr 2, 2026 at 6:06 PM Igor Korot <[email protected]> wrote: > >> Dave, >> >> On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <[email protected]> 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 <[email protected]> wrote: >> >> >> >> Ping… >> >> >> >> On Sun, Mar 29, 2026 at 5:20 PM Igor Korot <[email protected]> wrote: >> >>> >> >>> Dave, >> >>> >> >>> On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <[email protected]> >> wrote: >> >>> > >> >>> > Hi, Dave, >> >>> > >> >>> > >> >>> > On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <[email protected]> >> 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 <[email protected]> >> 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 <[email protected]> 2026-03-29 11:41 ` Dave Cramer <[email protected]> 2026-03-29 15:34 ` Igor Korot <[email protected]> 2026-03-30 00:20 ` Igor Korot <[email protected]> 2026-04-01 00:42 ` Igor Korot <[email protected]> 2026-04-01 09:24 ` Dave Cramer <[email protected]> 2026-04-03 01:06 ` Igor Korot <[email protected]> 2026-04-10 18:45 ` Igor Korot <[email protected]> 2026-04-11 08:58 ` Dave Cramer <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox