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>,
"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-03-14T15:25:08Z
Lists: 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