Re: Does included columns part of the PK

For all involved and interested:

The issue with ODBC driver has been fixed and will
be part of the next release.

Ref: https://github.com/postgresql-interfaces/psqlodbc/issues/170.

Thank you.

On Mon, Mar 16, 2026 at 6:11 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
> Adrian,,
>
> On Mon, Mar 16, 2026 at 5:44 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> >
> > On 3/16/26 4:38 PM, Igor Korot wrote:
> > > Adrian,
> > >
> > > Most important - do you agree that those fields should not be in this
> > > recordset?
> >
> > I don't see anything here:
> >
> > https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlprimarykeys-function?view=sql-server-ver17
> >
> > that says they should be returned. Though the above also says:
> >
> > " Additional columns beyond column 6 (PK_NAME) can be defined by the
> > driver."
> >
> > That is not the case here, where additional rows are used. However it
> > does allow for more information to be supplied.
> >
> > My purely un-expert analysis is, no the extra rows should not be there.
>
> Thx for confirming.
>
> I already forwarded the email with the query results over to ODBC list.
>
> Hopefully someone can come back soon.
>
> Are you reading that list as well? If not I will update this thread
> with the results.
>
> Thank you.
>
> >
> > >
> > > Thank you.
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com