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