pgsql: Make pg_dump --data-only try to order the table dumps so that

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make pg_dump --data-only try to order the table dumps so that
Date: 2008-09-08 15:26:23
Message-ID: 20080908152623.700017545A3@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Make pg_dump --data-only try to order the table dumps so that foreign keys'
referenced tables are dumped before the referencing tables. This avoids
failures when the data is loaded with the FK constraints already active.
If no such ordering is possible because of circular or self-referential
constraints, print a NOTICE to warn the user about it.

Modified Files:
--------------
pgsql/src/bin/pg_dump:
pg_dump.c (r1.499 -> r1.500)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.499&r2=1.500)
pg_dump.h (r1.140 -> r1.141)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.h?r1=1.140&r2=1.141)
pg_dump_sort.c (r1.20 -> r1.21)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump_sort.c?r1=1.20&r2=1.21)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2008-09-08 16:42:16 pgsql: Fix a couple of problems pointed out by Fujii Masao in the
Previous Message User Fxjr 2008-09-08 14:25:07 npgsql - Npgsql2: Added a test for bug 1006158