Re: Does included columns part of the PK - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Does included columns part of the PK
Date
Msg-id 2c31c118-7f8a-4359-9c4f-4cabd9df4262@aklaver.com
Whole thread Raw
In response to Re: Does included columns part of the PK  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Does included columns part of the PK
List pgsql-general
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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Using \copy to populate a table
Next
From: Tomas Vondra
Date:
Subject: Re: Replication to standby broke with WAL file corruption