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