Postgres Pro
Downloads
Home   >   mailing lists

Re: A generated column cannot be part of a partition key - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: A generated column cannot be part of a partition key
Date
Msg-id CAKFQuwbB5CZWw8jxxPfbFkTHjiepCSXt1osmFT7GhCPjPGVuvw@mail.gmail.com
Whole thread Raw
In response to Re: A generated column cannot be part of a partition key  (Diego Stammerjohann <diegostammer@gmail.com>)
Responses Re: A generated column cannot be part of a partition key
List pgsql-bugs
Tree view
On Tuesday, July 23, 2024, Diego Stammerjohann <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.  Maybe we need to rename Defaults to also reference Identity?

We should point out in 5.3 that Identity is not “generated” and ensure that we link to 5.3 when we use “generated column” elsewhere in the docs.

David J.

pgsql-bugs by date:

Previous
From: Diego Stammerjohann
Date:
Subject: Re: A generated column cannot be part of a partition key
Next
From: Peter Eisentraut
Date:
Subject: Re: A generated column cannot be part of a partition key