Feedback-ID: i76984098:Fastmail
Message-ID: <da939085-813e-4505-880d-aafa91c8509d@aklaver.com>
Date: Mon, 16 Mar 2026 14:40:20 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Does included columns part of the PK
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: pgsql-general <pgsql-general@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>
 <7461c77a-4536-4f53-b951-99b9ca33db79@aklaver.com>
 <CA+FnnTw+HhguiTO27hzTUTU6uRBY_wRRwB=xT+7=t_0CdrCsoA@mail.gmail.com>
 <105a9d1a-c219-401a-9b81-4d77dde901f5@aklaver.com>
Content-Language: en-US
In-Reply-To: <105a9d1a-c219-401a-9b81-4d77dde901f5@aklaver.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/da939085-813e-4505-880d-aafa91c8509d%40aklaver.com>
Precedence: bulk

On 3/16/26 2:30 PM, Adrian Klaver wrote:
> On 3/16/26 11:47 AM, Igor Korot wrote:
> 
> Reply to list also.
> Ccing list.
>> Adrian,
>>
>>
>>
>> On Mon, Mar 16, 2026, 8:03 AM Adrian Klaver <adrian.klaver@aklaver.com 
>> <mailto:adrian.klaver@aklaver.com>> wrote:
>>
>>     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 <https://bpa.st/Z2DWG>
>>
>>     I have no idea what this is trying to show?
>>
>>
>> The log shows ODBC connection and then at the end - call to 
>> SQLPrimaryKeys().
> 
> Where?
> 
> I don't see that in either the link you posted or the text file Greg 
> sent to the list.
> 
>>
>> If you run it against the table I posted above, you will get 3 fields. 
>> Whereas it should be just one.
> 
> Again, run it how?

Alright I see what you are talking about now. I'm not using the ODBC 
driver just it's query. In psql :

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


SELECT
     ta.attname,
     ia.attnum,
     ic.relname,
     n.nspname,
     tc.relname
FROM
     pg_catalog.pg_attribute ta,
     pg_catalog.pg_attribute ia,
     pg_catalog.pg_class tc,
     pg_catalog.pg_index i,
     pg_catalog.pg_namespace n,
     pg_catalog.pg_class ic
WHERE
     tc.relname = 'leagues_new'
     AND n.nspname = 'public'
     AND tc.oid = i.indrelid
     AND n.oid = tc.relnamespace
     AND i.indisprimary = 't'
     AND ia.attrelid = i.indexrelid
     AND ta.attrelid = i.indrelid
     AND ta.attnum = i.indkey[ia.attnum - 1]
     AND (NOT ta.attisdropped)
     AND (NOT ia.attisdropped)
     AND ic.oid = i.indexrelid
ORDER BY
     ia.attnum;

yields

attname   | attnum |     relname      | nspname |   relname
-------------+--------+------------------+---------+-------------
  id          |      1 | leagues_new_pkey | public  | leagues_new
  drafttype   |      2 | leagues_new_pkey | public  | leagues_new
  scoringtype |      3 | leagues_new_pkey | public  | leagues_new


> 
>>
>> Thank you.
>>


-- 
Adrian Klaver
adrian.klaver@aklaver.com