|
12 | 12 | *by PostgreSQL |
13 | 13 | * |
14 | 14 | * IDENTIFICATION |
15 | | - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.344 2003/08/08 01:21:02 momjian Exp $ |
| 15 | + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.345 2003/08/28 18:59:06 tgl Exp $ |
16 | 16 | * |
17 | 17 | *------------------------------------------------------------------------- |
18 | 18 | */ |
@@ -588,6 +588,7 @@ main(int argc, char **argv) |
588 | 588 | MoveToEnd(g_fout,"BLOBS"); |
589 | 589 | MoveToEnd(g_fout,"INDEX"); |
590 | 590 | MoveToEnd(g_fout,"CONSTRAINT"); |
| 591 | +MoveToEnd(g_fout,"FK CONSTRAINT"); |
591 | 592 | MoveToEnd(g_fout,"TRIGGER"); |
592 | 593 | MoveToEnd(g_fout,"RULE"); |
593 | 594 | MoveToEnd(g_fout,"SEQUENCE SET"); |
@@ -6039,6 +6040,8 @@ dumpOneSequence(Archive *fout, TableInfo *tbinfo, |
6039 | 6040 | * |
6040 | 6041 | * Dump out constraints after all table creation statements in |
6041 | 6042 | * an alter table format. Currently handles foreign keys only. |
| 6043 | + * (Unique and primary key constraints are handled with indexes, |
| 6044 | + * while check constraints are merged into the table definition.) |
6042 | 6045 | * |
6043 | 6046 | * XXX Potentially wrap in a 'SET CONSTRAINTS OFF' block so that |
6044 | 6047 | * the current table data is not processed |
@@ -6130,7 +6133,7 @@ dumpConstraints(Archive *fout, TableInfo *tblinfo, int numTables) |
6130 | 6133 | conName, |
6131 | 6134 | tbinfo->relnamespace->nspname, |
6132 | 6135 | tbinfo->usename, |
6133 | | -"CONSTRAINT",NULL, |
| 6136 | +"FKCONSTRAINT",NULL, |
6134 | 6137 | query->data,delqry->data, |
6135 | 6138 | NULL,NULL,NULL); |
6136 | 6139 |
|
|