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

From Francisco Olarte
Subject Re: A generated column cannot be part of a partition key
Date
Msg-id CA+bJJbwWVmJFfw-2YYA4Nksrq_k-PY9z6E8jPHXD26GHDh8kGQ@mail.gmail.com
Whole thread Raw
In response to Re: A generated column cannot be part of a partition key  (Diego Stammerjohann <diegostammer@gmail.com>)
Responses Re: A generated column cannot be part of a partition key
List pgsql-bugs
Diego:

On Tue, 23 Jul 2024 at 14:01, Diego Stammerjohann
<diegostammer@gmail.com> wrote:
> OK, that sounds good to me.
Due to top posting I am unable to discern what part sounds good.

> So, the documentation should be update to something like this:
> "An expression based generated column cannot be part of a partition key."
> Sounds fair?

Sounds good, but if you analyze it there is no such thing as "An
expression based generated column" defined. There are generated
columns and identity columns. Unfortunately both use the keyword
GENERATED in their definition / creation, probably due to some
standard committee shenanigans.

Francisco Olarte.



pgsql-bugs by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: A generated column cannot be part of a partition key
Next
From: Diego Stammerjohann
Date:
Subject: Re: A generated column cannot be part of a partition key