Re: Does included columns part of the PK - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Does included columns part of the PK
Date
Msg-id e612ab0e-37c9-4dc2-8cec-9c5fe9baf284@aklaver.com
Whole thread Raw
In response to Re: Does included columns part of the PK  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Does included columns part of the PK
List pgsql-general
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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Does included columns part of the PK
Next
From: Igor Korot
Date:
Subject: Re: Does included columns part of the PK