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