Re: Does included columns part of the PK

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Does included columns part of the PK
Date: 2026-03-14 16:56:55
Message-ID: CA+FnnTyFVn4Ebx9kP-5vooZwpATwV5Euc8Nt6TGmEuR6oDYd9A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Hi,

On Sat, Mar 14, 2026 at 8:51 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Saturday, March 14, 2026, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> 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.
>>
>
> They are referring to the unique index that backs the PK constraint.
>

Not “they” - “He”. 😊

And yes - that’s what I’m referring to.

Thank you.

> David J.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2026-03-14 23:30:19 Re: Does included columns part of the PK
Previous Message David G. Johnston 2026-03-14 15:51:24 Re: Does included columns part of the PK

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2026-03-14 23:30:19 Re: Does included columns part of the PK
Previous Message David G. Johnston 2026-03-14 15:51:24 Re: Does included columns part of the PK