Обсуждение: compatibility issue - problem with migrating from Postgres 11

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