NotificationsYou must be signed in to change notification settings
Fork5
Star27

Commita09ccc7

committed

If they're not, the below causes problems, as the foreign key is added

after the CHECK. Cluster depends on the index name, so I thought itwise to ensure all names are available, rather than leaving off theCONSTRAINT "$n" portion for internally named constraints.CREATE TABLE jkey (col integer primary key);CREATE TABLE j (col integer REFERENCES jkey);ALTER TABLE j ADD CHECK(col > 5);This is a problem in 7.3 series as well as -Tip.Rod Taylor <rbt@rbt.ca>

1 parentca64391 commita09ccc7Copy full SHA for a09ccc7

File tree

1 file changed

-3

lines changed

src/bin/pg_dump
- pg_dump.c

1 file changed

-3

lines changed

`‎src/bin/pg_dump/pg_dump.c‎`

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -12,7 +12,7 @@`
`12`	`12`	`*by PostgreSQL`
`13`	`13`	`*`
`14`	`14`	`* IDENTIFICATION`
`15`		`- * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.334 2003/06/2503:56:31 momjian Exp $`
	`15`	`+ * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.335 2003/06/2504:08:19 momjian Exp $`
`16`	`16`	`*`
`17`	`17`	`*-------------------------------------------------------------------------`
`18`	`18`	`*/`
`@@ -5347,8 +5347,7 @@ dumpOneTable(Archive fout, TableInfo tbinfo, TableInfo *g_tblinfo)`
`5347`	`5347`	`if (actual_atts+j>0)`
`5348`	`5348`	`appendPQExpBuffer(q,",\n ");`
`5349`	`5349`
`5350`		`-if (name[0]!='$')`
`5351`		`-appendPQExpBuffer(q,"CONSTRAINT %s ",`
	`5350`	`+appendPQExpBuffer(q,"CONSTRAINT %s ",`
`5352`	`5351`	`fmtId(name));`
`5353`	`5352`	`appendPQExpBuffer(q,"%s",expr);`
`5354`	`5353`	`}`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commita09ccc7

File tree

1 file changed

1 file changed

`‎src/bin/pg_dump/pg_dump.c‎`

0 commit comments