Re: pg_dump of partitioned table not working. - Mailing list pgsql-general

From Ron
Subject Re: pg_dump of partitioned table not working.
Date
Msg-id f57cc88f-50bb-e5bb-5f9d-8a25b2008eb9@gmail.com
Whole thread Raw
In response to Re: pg_dump of partitioned table not working.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On 12/2/20 6:21 PM, David G. Johnston wrote:
On Wed, Dec 2, 2020 at 5:14 PM Ron <ronljohnsonjr@gmail.com> wrote:

> It does seem like there might be reason to have a switch along
> the lines of "--include-child-tables".

That would be great, but won't help me in v12.


I'd probably just relocate the table to a separate schema and require that all partitions are placed there as well.  Otherwise, the necessary information exists in the catalogs, so a solution is within reach (minor concern regarding concurrency).

That's doable, but the developer (of the very large mission-critical existing application) would probably push back.

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_dump of partitioned table not working.
Next
From: Ron
Date:
Subject: Re: pg_dump of partitioned table not working.