diff options
| author | Tom Lane | 2003-08-28 18:59:06 +0000 |
|---|---|---|
| committer | Tom Lane | 2003-08-28 18:59:06 +0000 |
| commit | 80bc61c849da7faf24b5eb6c58034180f761bc33 (patch) | |
| tree | 565074bf94d11be25a8f0d305a6c1c8355cc33bf /src | |
| parent | ce2ab4131aadee0070987bbefd3e57781198c54c (diff) | |
Ensure that FK constraints are dumped after primary/unique constraints,
rather than relying on OID order of pg_constraint entries. Per gripe
from Greg Stark.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 9b25ac5e9ba..6c0ef4f35e7 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -12,7 +12,7 @@ * by PostgreSQL * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.344 2003/08/08 01:21:02 momjian Exp $ + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.345 2003/08/28 18:59:06 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -588,6 +588,7 @@ main(int argc, char **argv) MoveToEnd(g_fout, "BLOBS"); MoveToEnd(g_fout, "INDEX"); MoveToEnd(g_fout, "CONSTRAINT"); + MoveToEnd(g_fout, "FK CONSTRAINT"); MoveToEnd(g_fout, "TRIGGER"); MoveToEnd(g_fout, "RULE"); MoveToEnd(g_fout, "SEQUENCE SET"); @@ -6039,6 +6040,8 @@ dumpOneSequence(Archive *fout, TableInfo *tbinfo, * * Dump out constraints after all table creation statements in * an alter table format. Currently handles foreign keys only. + * (Unique and primary key constraints are handled with indexes, + * while check constraints are merged into the table definition.) * * XXX Potentially wrap in a 'SET CONSTRAINTS OFF' block so that * the current table data is not processed @@ -6130,7 +6133,7 @@ dumpConstraints(Archive *fout, TableInfo *tblinfo, int numTables) conName, tbinfo->relnamespace->nspname, tbinfo->usename, - "CONSTRAINT", NULL, + "FK CONSTRAINT", NULL, query->data, delqry->data, NULL, NULL, NULL); |