Feedback-ID: i76984098:Fastmail
Message-ID: <7461c77a-4536-4f53-b951-99b9ca33db79@aklaver.com>
Date: Mon, 16 Mar 2026 08:03:42 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Does included columns part of the PK
To: Igor Korot <ikorot01@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: 
 <CA+FnnTz7+dbyk5Gn2iM-eo1Xvfax15yjBevmCCfvo0-UVW1K7Q@mail.gmail.com>
 <b3f6ecfb-8772-4e15-a772-8e64fb573d49@aklaver.com>
 <CAKFQuwYswndGOm6vnsoNSTWHEC5d29bvYokymtDEY_cyW54FEQ@mail.gmail.com>
 <CA+FnnTyFVn4Ebx9kP-5vooZwpATwV5Euc8Nt6TGmEuR6oDYd9A@mail.gmail.com>
 <3547f40b-08b9-4d0c-bba8-f1c26d0bf09d@aklaver.com>
 <CA+FnnTwLvp1wweqWJkw1+sg4x+pM_oGVmfc-3TaPpE_557=A_A@mail.gmail.com>
 <2c31c118-7f8a-4359-9c4f-4cabd9df4262@aklaver.com>
 <CA+FnnTx5WZeYwg-OFwvbipvHRJP263UP8EVNY0aGMu6E_XuKsQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: 
 <CA+FnnTx5WZeYwg-OFwvbipvHRJP263UP8EVNY0aGMu6E_XuKsQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/7461c77a-4536-4f53-b951-99b9ca33db79%40aklaver.com>
Precedence: bulk

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.klaver@aklaver.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.klaver@aklaver.com


-- 
Adrian Klaver
adrian.klaver@aklaver.com