pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter@eisentraut.org>
To: David G. Johnston <david.g.johnston@gmail.com>
To: Diego Stammerjohann <diegostammer@gmail.com>
Cc: Francisco Olarte <folarte@peoplecall.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: A generated column cannot be part of a partition key
Date: Tue, 23 Jul 2024 16:51:06 +0200
Message-ID: <64060b2a-1f93-48c4-b042-baf0db6239fc@eisentraut.org> (raw)
In-Reply-To: <CAKFQuwbB5CZWw8jxxPfbFkTHjiepCSXt1osmFT7GhCPjPGVuvw@mail.gmail.com>
References: <CAJ7eQr01Gb4iHiGUHAeSxFph76EAjo1up_4SfMzroN_LRZ2a6g@mail.gmail.com>
	<CA+bJJbwe4yJAjyVWu6_5JmNYRW5T3zyqr2UtEGsqWPjxwVPM2A@mail.gmail.com>
	<CAJ7eQr1W_B-dyHA6fQZGAdEF=YFt3QfUtZFaG8TDRxbnH1FfWA@mail.gmail.com>
	<CA+bJJbwWVmJFfw-2YYA4Nksrq_k-PY9z6E8jPHXD26GHDh8kGQ@mail.gmail.com>
	<CAJ7eQr027fE8qJTpudjf-b2wNLoU_Ax4FwpcWF277uPFfJ2zCw@mail.gmail.com>
	<CAKFQuwbB5CZWw8jxxPfbFkTHjiepCSXt1osmFT7GhCPjPGVuvw@mail.gmail.com>

On 23.07.24 16:18, David G. Johnston wrote:
> On Tuesday, July 23, 2024, Diego Stammerjohann <diegostammer@gmail.com 
> <mailto:diegostammer@gmail.com>> wrote:
> 
>     So, for me, it would be good to have in some place the information
>     that an IDENTITY column is not a GENERATED column. That's what
>     caused confusion to me.
> 
> 
> Yeah, 5.3 defines what generated columns are and does not include 
> identity.  But nothing in Chapter 5 discusses identity which seems like 
> a bug if Chapter 5 is intended be the official reference for concepts.

This has been changed in the documentation for PG 17.  There are now 
separate sections for identity columns and generated columns:

https://www.postgresql.org/docs/17/ddl-identity-columns.html
https://www.postgresql.org/docs/17/ddl-generated-columns.html






view thread (8+ messages)

Message-ID: <64060b2a-1f93-48c4-b042-baf0db6239fc@eisentraut.org>
Permalink:  ../64060b2a-1f93-48c4-b042-baf0db6239fc@eisentraut.org/
Also on:    postgresql.org/message-id/64060b2a-1f93-48c4-b042-baf0db6239fc@eisentraut.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: peter@eisentraut.org, david.g.johnston@gmail.com, diegostammer@gmail.com, folarte@peoplecall.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: A generated column cannot be part of a partition key
  In-Reply-To: <64060b2a-1f93-48c4-b042-baf0db6239fc@eisentraut.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox