Re: pg_dump is broken for partition tablespaces

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: David Rowley <david.rowley@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2019-04-10T16:10:55Z

Lists: pgsql-hackers

Hi,

On 2019-04-10 09:28:21 -0400, Alvaro Herrera wrote:
> So I think that apart from David's patch, we should just document all
> these things carefully.

Yea, I think that's the most important part.

I'm not convinced that we should have any inheriting behaviour btw - it
seems like there's a lot of different ways to think this should behave,
with different good reason each.

Greetings,

Andres Freund

Commits

Make pg_dump emit ATTACH PARTITION instead of PARTITION OF (reprise)
- 6a781c4f5fec 11.4 landed
- 33a53130a894 12.0 landed
- 1eb8a5ea463d 10.9 landed
Fix tablespace inheritance for partitioned rels
- 87259588d0ab 12.0 landed
Make pg_dump emit ATTACH PARTITION instead of PARTITION OF
- a98c48debcd0 11.3 landed
- 5a191f697400 10.8 landed
- 3b23552ad8bb 12.0 landed
Make sure ALTER TABLE preserves index tablespaces.
- bd673e8e864a 10.0 cited