Hi Rushabh, While testing latest v2 patch, I got a crash when using --load-via-partition-root with --schema options. Below are steps to reproduce.
--create below test data create schema a; create schema b; create schema c; create table t1 (a int,b text) partition by list(a); create table a.t1_p1 partition of t1 FOR VALUES in (1,2,3,4) partition by list(a); create table b.t1_p1_p1 partition of a.t1_p1 FOR VALUES in (1,2); create table c.t1_p1_p2 partition of a.t1_p1 FOR VALUES in (3,4); create table b.t1_p2 partition of t1 FOR VALUES in (5,6,7,8) partition by list(a); create table a.t1_p2_p1 partition of b.t1_p2 FOR VALUES in (5,6); create table t1_p2_p2 partition of b.t1_p2 FOR VALUES in (7,8); insert into t1 values (8,'t1'); insert into a.t1_p1 values (2,'a.t1_p1'); insert into b.t1_p1_p1 values (1,'b.t1_p1_p1'); insert into c.t1_p1_p2 values (3,'c.t1_p1_p2'); insert into b.t1_p2 values (6,'b.t1_p2'); insert into a.t1_p2_p1 values (5,'a.t1_p2_p1'); insert into t1_p2_p2 values (7,'t1_p2_p1'); insert into t1 values (4 ,'t1'); --trying to take pg_dump [edb@localhost bin]$ ./pg_dump -d postgres --schema=a -f d1.dump -Fp [edb@localhost bin]$ ./pg_dump -d postgres --load-via-partition-root -f d2.dump -Fp [edb@localhost bin]$ ./pg_dump -d postgres --load-via-partition-root --schema=a -f d3.dump -Fp pg_dump: pg_dump.c:2063: getRootTableInfo: Assertion `tbinfo->numParents == 1' failed. Aborted (core dumped) Thanks & Regards, Rajkumar Raghuwanshi QMG, EnterpriseDB Corporation On Fri, Aug 4, 2017 at 3:01 PM, Rushabh Lathia <rushabh.lat...@gmail.com> wrote: > > Here is an update patch, now renamed the switch to > --load-via-partition-root > and also added the documentation for the new switch into pg_dump as well > as pg_dumpall. > > > On Fri, Aug 4, 2017 at 7:13 AM, Amit Langote < > langote_amit...@lab.ntt.co.jp> wrote: > >> On 2017/08/04 1:08, David G. Johnston wrote: >> > On Thu, Aug 3, 2017 at 8:53 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> > >> >> Robert Haas <robertmh...@gmail.com> writes: >> >>> So maybe --load-via-partition-root if nobody likes my previous >> >>> suggestion of --partition-data-via-root ? >> >> >> >> WFM. >> >> >> > >> > +1 >> >> +1. >> >> Thanks, >> Amit >> >> > > > Thanks, > Rushabh Lathia > www.EnterpriseDB.com > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > >
