Horton
Menu

Re: A generated column cannot be part of a partition key

Peter Eisentraut <peter@eisentraut.org>

View thread
From: Peter Eisentraut <peter@eisentraut.org>
To: "David G. Johnston" <david.g.johnston@gmail.com>, Diego Stammerjohann <diegostammer@gmail.com>
Cc: Francisco Olarte <folarte@peoplecall.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2024-07-23T14:51:06Z
Lists: pgsql-bugs 
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