| 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-15 15:34:13 |
| Message-ID: | 2c31c118-7f8a-4359-9c4f-4cabd9df4262@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
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:
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2026-03-15 23:09:05 | Re: Replication to standby broke with WAL file corruption |
| Previous Message | Adrian Klaver | 2026-03-15 15:30:44 | Re: Using \copy to populate a table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2026-03-16 01:23:57 | Re: Does included columns part of the PK |
| Previous Message | Igor Korot | 2026-03-15 06:24:38 | Re: Does included columns part of the PK |