From: | Diego Stammerjohann <diegostammer(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | A generated column cannot be part of a partition key |
Date: | 2024-07-22 22:37:08 |
Message-ID: | CAJ7eQr01Gb4iHiGUHAeSxFph76EAjo1up_4SfMzroN_LRZ2a6g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksander Alekseev | 2024-07-23 08:33:05 | Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. |
Previous Message | Tom Lane | 2024-07-22 16:36:57 | Re: BUG #18549: Support ipv6 link-local addresses in the inet type |