| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(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 01:23:57 |
| Message-ID: | CA+FnnTx5WZeYwg-OFwvbipvHRJP263UP8EVNY0aGMu6E_XuKsQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
Hi, Adrian,
Here is the log file from running in ODBC mode: https://bpa.st/Z2DWG
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ishan joshi | 2026-03-16 06:04:51 | Re: Replication to standby broke with WAL file corruption |
| Previous Message | Tomas Vondra | 2026-03-15 23:38:54 | Re: Index scan with bitmap filter - has this been explored |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2026-03-16 13:53:11 | Re: Does included columns part of the PK |
| Previous Message | Adrian Klaver | 2026-03-15 15:34:13 | Re: Does included columns part of the PK |