Feedback-ID: ie0a040ee:Fastmail
Message-ID: <64060b2a-1f93-48c4-b042-baf0db6239fc@eisentraut.org>
Date: Tue, 23 Jul 2024 16:51:06 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: A generated column cannot be part of a partition key
To: "David G. Johnston" <david.g.johnston@gmail.com>,
 Diego Stammerjohann <diegostammer@gmail.com>
Cc: Francisco Olarte <folarte@peoplecall.com>,
 "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
References: 
 <CAJ7eQr01Gb4iHiGUHAeSxFph76EAjo1up_4SfMzroN_LRZ2a6g@mail.gmail.com>
 <CA+bJJbwe4yJAjyVWu6_5JmNYRW5T3zyqr2UtEGsqWPjxwVPM2A@mail.gmail.com>
 <CAJ7eQr1W_B-dyHA6fQZGAdEF=YFt3QfUtZFaG8TDRxbnH1FfWA@mail.gmail.com>
 <CA+bJJbwWVmJFfw-2YYA4Nksrq_k-PY9z6E8jPHXD26GHDh8kGQ@mail.gmail.com>
 <CAJ7eQr027fE8qJTpudjf-b2wNLoU_Ax4FwpcWF277uPFfJ2zCw@mail.gmail.com>
 <CAKFQuwbB5CZWw8jxxPfbFkTHjiepCSXt1osmFT7GhCPjPGVuvw@mail.gmail.com>
Content-Language: en-US
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: 
 <CAKFQuwbB5CZWw8jxxPfbFkTHjiepCSXt1osmFT7GhCPjPGVuvw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/64060b2a-1f93-48c4-b042-baf0db6239fc%40eisentraut.org>
Precedence: bulk

On 23.07.24 16:18, David G. Johnston wrote:
> On Tuesday, July 23, 2024, Diego Stammerjohann <diegostammer@gmail.com 
> <mailto: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.

This has been changed in the documentation for PG 17.  There are now 
separate sections for identity columns and generated columns:

https://www.postgresql.org/docs/17/ddl-identity-columns.html
https://www.postgresql.org/docs/17/ddl-generated-columns.html