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

From Erik Wienhold
Subject Re: A generated column cannot be part of a partition key
Date
Msg-id 5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6@ewie.name
Whole thread Raw
In response to Re: A generated column cannot be part of a partition key  (Diego Stammerjohann <diegostammer@gmail.com>)
List 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



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18550: Cross-partition update of a former inheritance parent leads to an assertion failure
Next
From: Francisco Olarte
Date:
Subject: Re: A generated column cannot be part of a partition key