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

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Make pg_dump --data-only try to order the table dumps so that
Date
Msg-id 20080908152623.700017545A3@cvs.postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: fxjr@pgfoundry.org (User Fxjr)
Date:
Subject: npgsql - Npgsql2: Added a test for bug 1006158
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix a couple of problems pointed out by Fujii Masao in the