Re: Does included columns part of the PK

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does included columns part of the PK
Date: 2026-03-17 00:44:45
Message-ID: e612ab0e-37c9-4dc2-8cec-9c5fe9baf284@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

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.

>
> Thank you.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2026-03-17 01:11:26 Re: Does included columns part of the PK
Previous Message Igor Korot 2026-03-16 23:38:22 Re: Does included columns part of the PK

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-03-17 01:11:26 Re: Does included columns part of the PK
Previous Message Igor Korot 2026-03-16 23:38:22 Re: Does included columns part of the PK