A generated column cannot be part of a partition key

Diego Stammerjohann <diegostammer@gmail.com>

From: Diego Stammerjohann <diegostammer@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Date: 2024-07-22T22:37:08Z
Lists: pgsql-bugs
 Hello,

 In the documentation (
https://www.postgresql.org/docs/current/ddl-generated-columns.html),
there's the following statement:

 A generated column cannot be part of a partition key

 However, I was able to create a partitioned table using the generated
column, as follows:

 CREATE TABLE "partitioned_table"
 (
   "id" bigint NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1
INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1),
   "text_value" VARCHAR(100) NOT NULL,
   CONSTRAINT "pk_partitioned_table" PRIMARY KEY ("id") WITH
(fillfactor='100')
 ) PARTITION BY RANGE ("id");

 CREATE TABLE "partition_table_01" PARTITION OF "partitioned_table" FOR
VALUES FROM (1)        TO (10000000);
 CREATE TABLE "partition_table_02" PARTITION OF "partitioned_table" FOR
VALUES FROM (10000000) TO (20000000);

Diego