compatibility issue - problem with migrating from Postgres 11 - Mailing list pgsql-hackers

From Pavel Stehule
Subject compatibility issue - problem with migrating from Postgres 11
Date
Msg-id CAFj8pRDLYjvGAwaFx+nYPzaHCNgjiU0PV67J-LiyiFFo1OWtVQ@mail.gmail.com
Whole thread Raw
List 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


Are there some plans to fix this issue?

Regards

Pavel

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: postgres_fdw - make cached connection functions tests meaningful
Next
From: Alexander Korotkov
Date:
Subject: Re: PG 14 release notes, first draft