A generated column cannot be part of a partition key

 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