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

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: Dave Cramer <davecramer(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-10 18:45:11
Message-ID: CA+FnnTx8ZA2vHj_Bm=NMcc2q7fxjazZU40Wo3qA8hSN=sQSnMw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Ping.

Did anybody look into this?

Thank you.

On Thu, Apr 2, 2026 at 6:06 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> Dave,
>
> On Wed, Apr 1, 2026 at 2:24 AM Dave Cramer <davecramer(at)gmail(dot)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(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 Dave Cramer 2026-04-11 08:58:49 Re: Included fields should not be a part of SQLPrimaryKey()
Previous Message Igor Korot 2026-04-03 01:06:55 Re: Included fields should not be a part of SQLPrimaryKey()