Hello,
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
