Feedback-ID: i76984098:Fastmail
Message-ID: <b3f6ecfb-8772-4e15-a772-8e64fb573d49@aklaver.com>
Date: Sat, 14 Mar 2026 08:25:08 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Does included columns part of the PK
To: Igor Korot <ikorot01@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: 
 <CA+FnnTz7+dbyk5Gn2iM-eo1Xvfax15yjBevmCCfvo0-UVW1K7Q@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: 
 <CA+FnnTz7+dbyk5Gn2iM-eo1Xvfax15yjBevmCCfvo0-UVW1K7Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/b3f6ecfb-8772-4e15-a772-8e64fb573d49%40aklaver.com>
Precedence: bulk

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