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

Erik Wienhold <ewie@ewie.name>

From: Erik Wienhold <ewie@ewie.name>
To: Diego Stammerjohann <diegostammer@gmail.com>
Cc: Francisco Olarte <folarte@peoplecall.com>, pgsql-bugs@lists.postgresql.org
Date: 2024-07-23T13:31:13Z
Lists: pgsql-bugs
On 2024-07-23 14:01 +0200, Diego Stammerjohann wrote:
> So, the documentation should be update to something like this:
> 
> "An expression based generated column cannot be part of a partition key."
> 
> Sounds fair?

I think that change is unnecessarily confusing since that page only
talks about those generated columns.  Note that pg17 will also document
identity columns[1], right before that generated columns section.  Not
sure if generated != identity should be made explicit when the preceding
section introduces identity columns.

[1] https://www.postgresql.org/docs/17/ddl-identity-columns.html

-- 
Erik