Date: Tue, 23 Jul 2024 15:31:13 +0200
From: Erik Wienhold <ewie@ewie.name>
To: Diego Stammerjohann <diegostammer@gmail.com>
Cc: Francisco Olarte <folarte@peoplecall.com>,
	pgsql-bugs@lists.postgresql.org
Subject: Re: A generated column cannot be part of a partition key
Message-ID: <5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6@ewie.name>
References: 
 <CAJ7eQr01Gb4iHiGUHAeSxFph76EAjo1up_4SfMzroN_LRZ2a6g@mail.gmail.com>
 <CA+bJJbwe4yJAjyVWu6_5JmNYRW5T3zyqr2UtEGsqWPjxwVPM2A@mail.gmail.com>
 <CAJ7eQr1W_B-dyHA6fQZGAdEF=YFt3QfUtZFaG8TDRxbnH1FfWA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAJ7eQr1W_B-dyHA6fQZGAdEF=YFt3QfUtZFaG8TDRxbnH1FfWA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6%40ewie.name>
Precedence: bulk

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