Re: Does included columns part of the PK

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "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-16 15:03:42
Message-ID: 7461c77a-4536-4f53-b951-99b9ca33db79@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

On 3/15/26 6:23 PM, Igor Korot wrote:
> Hi, Adrian,
>
> Here is the log file from running in ODBC mode: https://bpa.st/Z2DWG

I have no idea what this is trying to show?

Is it referring to the thread I linked to below:

"CREATE TABLE fails"

or this thread?

In any case what actions on the client action where done and how did
they not match expectations?

If this was really about the "CREATE TABLE fails" thread it needs to go
back there.

As to this thread go back to:

https://www.postgresql.org/message-id/3547f40b-08b9-4d0c-bba8-f1c26d0bf09d%40aklaver.com

and provide the information requested.

>
> Thank you.
>
> On Sun, Mar 15, 2026 at 10:34 AM Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>>
>> On 3/14/26 11:24 PM, Igor Korot wrote:
>>> Hi, Adrian,
>>
>>>
>>> Lets start with the beginning:
>>>
>>> draft=# CREATE TABLE leagues_new(id serial, name varchar(100),
>>> drafttype smallint, scoringtype smallint, roundvalues smallint,
>>> leaguetype char(5), salary integer, benchplayers smallint, primary
>>> key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50,
>>> deduplicate_items = OFF ));
>>> CREATE TABLE
>>> draft=#
>>
>> I think the above is for this thread:
>>
>> https://www.postgresql.org/message-id/CA%2BFnnTyGEM-1mwxKPbwFTOodf%2BYUX%3DTxTmBPY5S%3DYh1h%3DoVY9A%40mail.gmail.com
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Masahiko Sawada 2026-03-16 18:24:58 Re: Emitting JSON to file using COPY TO
Previous Message Greg Sabino Mullane 2026-03-16 13:53:11 Re: Does included columns part of the PK

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-03-16 18:43:13 Re: Does included columns part of the PK
Previous Message Greg Sabino Mullane 2026-03-16 13:53:11 Re: Does included columns part of the PK