| 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.
>
| 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 |
| 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 |