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 b3f6ecfb-8772-4e15-a772-8e64fb573d49@aklaver.com
Whole thread Raw
In response to 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/14/26 12:09 AM, Igor Korot wrote:
> Hi, ALL,
> Have one weird question ;-)
> 
> When I connect with ODBC and call SQLPrimaryKey() the function returns

Are you actually using the SQLPrimaryKeys(), not SQLPrimaryKey()?

> all fields including
> "included" fields.

Define 'included' fields.

> I'm getting only direct PK fields.

Define direct PK fields.

> 
> I presume that libpq is correct and the ODBC driver is the one that
> needs to be fixed.

Returning the actual results from each case would help.

Have you cranked up the logging on the Postgres server to see what query 
ODBC is using?

> 
> Just wanted to ask this list before going to complain to the ODBC list... ;-)
> 
> Thank you.
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: compatibility between PostgreSQL JDBC driver version 42.7.10 and Java 25
Next
From: "David G. Johnston"
Date:
Subject: Re: Does included columns part of the PK