Re: A generated column cannot be part of a partition key
Francisco Olarte <folarte@peoplecall.com>
From: Francisco Olarte <folarte@peoplecall.com>
To: Diego Stammerjohann <diegostammer@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2024-07-23T13:57:45Z
Lists: 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.