pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Erik Wienhold <ewie@ewie.name>
To: Diego Stammerjohann <diegostammer@gmail.com>
Cc: Francisco Olarte <folarte@peoplecall.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: A generated column cannot be part of a partition key
Date: Tue, 23 Jul 2024 15:31:13 +0200
Message-ID: <5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6@ewie.name> (raw)
In-Reply-To: <CAJ7eQr1W_B-dyHA6fQZGAdEF=YFt3QfUtZFaG8TDRxbnH1FfWA@mail.gmail.com>
References: <CAJ7eQr01Gb4iHiGUHAeSxFph76EAjo1up_4SfMzroN_LRZ2a6g@mail.gmail.com>
	<CA+bJJbwe4yJAjyVWu6_5JmNYRW5T3zyqr2UtEGsqWPjxwVPM2A@mail.gmail.com>
	<CAJ7eQr1W_B-dyHA6fQZGAdEF=YFt3QfUtZFaG8TDRxbnH1FfWA@mail.gmail.com>

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





view thread (8+ messages)  latest in thread

Message-ID: <5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6@ewie.name>
Permalink:  ../5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6@ewie.name/
Also on:    postgresql.org/message-id/5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6@ewie.name

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: ewie@ewie.name, diegostammer@gmail.com, folarte@peoplecall.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: A generated column cannot be part of a partition key
  In-Reply-To: <5e0f61a3-30ba-4ba8-ab9b-e78e3fbf10e6@ewie.name>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox