| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | compatibility issue - problem with migrating from Postgres 11 |
| Date: | 2021-05-10 12:39:17 |
| Message-ID: | CAFj8pRDLYjvGAwaFx+nYPzaHCNgjiU0PV67J-LiyiFFo1OWtVQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
my customer reported an issue related to unsupported TABLESPACE pg_default
for partitioned table:
postgres=# CREATE TABLE IF NOT EXISTS foo2
(
data bytea,
guid character varying(255) COLLATE pg_catalog."default" NOT NULL,
part date NOT NULL,
retention_period integer,
CONSTRAINT document_data_bytea_pkey1 PRIMARY KEY (guid, part)
) PARTITION BY RANGE (part)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ERROR: cannot specify default tablespace for partitioned relations
This check is two years old
https://github.com/postgres/postgres/commit/87259588d0ab0b8e742e30596afa7ae25caadb18#diff-f2c91c95b7f2a84d916138e0af4338859803a03cee0d7e2e710fbcb869c59d0c
Are there some plans to fix this issue?
Regards
Pavel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2021-05-10 13:02:27 | Re: PG 14 release notes, first draft |
| Previous Message | Bharath Rupireddy | 2021-05-10 12:32:56 | postgres_fdw - make cached connection functions tests meaningful |