Re: Does included columns part of the PK

Adrian Klaver <adrian.klaver@aklaver.com>

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2026-03-17T00:44:45Z
Lists: 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