From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | David Rowley <drowley(at)postgresql(dot)org>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_dump, ATTACH, and independently restorable child partitions |
Date: | 2020-10-29 17:00:20 |
Message-ID: | 20201029170020.GA31710@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sat, Oct 24, 2020 at 02:59:49PM -0500, Justin Pryzby wrote:
> On Fri, Oct 23, 2020 at 12:29:40AM -0500, Justin Pryzby wrote:
> > Since this commit, pg_dump CREATEs tables and then ATTACHes them:
> >
> > |commit 33a53130a89447e171a8268ae0b221bb48af6468
> > |Author: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
> > |Date: Mon Jun 10 18:56:23 2019 -0400
> > |
> > | Make pg_dump emit ATTACH PARTITION instead of PARTITION OF (reprise)
> > |...
> > | This change also has the advantage that the partition is restorable from
> > | the dump (as a standalone table) even if its parent table isn't
> > | restored.
> >
> > I like the idea of child tables being independently restorable, but it doesn't
> > seem to work.
> ...
> > Now that I look, it seems like this is calling PQexec(), which sends a single,
> > "simple" libpq message with:
> > |CREATE TABLE ..; ALTER TABLE .. ATTACH PARTITION;
> > ..which is transactional, so when the 2nd command fails, the CREATE is rolled back.
> > https://www.postgresql.org/docs/9.5/libpq-exec.html#LIBPQ-EXEC-MAIN
>
> The easy fix is to add an explicit begin/commit.
Now with updated test script.
--
Justin
Attachment | Content-Type | Size |
---|---|---|
v2-0001-pg_dump-Allow-child-partitions-to-be-independentl.patch | text/x-diff | 2.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-10-29 17:35:08 | Re: duplicate function oid symbols |
Previous Message | Alvaro Herrera | 2020-10-29 16:35:07 | Re: Autovacuum worker doesn't immediately exit on postmaster death |