NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit9fecf30

committed

Seems my check constraint change did break stuff.

Alias the appropriate columns back to their original name.Fixed formatting of a few other places as I went along (indenting)--Rod Taylor <rbt@rbt.ca>

1 parent187e865 commit9fecf30Copy full SHA for 9fecf30

File tree

1 file changed

-7

lines changed

src/bin/pg_dump
- pg_dump.c

1 file changed

-7

lines changed

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

Lines changed: 7 additions & 7 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.336 2003/07/23 08:47:30 petere Exp $`
	`15`	`+ * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.337 2003/07/25 19:37:21 momjian Exp $`
`16`	`16`	`*`
`17`	`17`	`*-------------------------------------------------------------------------`
`18`	`18`	`*/`
`@@ -3304,13 +3304,13 @@ dumpOneDomain(Archive fout, TypeInfo tinfo)`
`3304`	`3304`	`* Fetch and process CHECK constraints for the domain`
`3305`	`3305`	`*/`
`3306`	`3306`	`if (g_fout->remoteVersion >=70400)`
`3307`		`-appendPQExpBuffer(chkquery,"SELECT conname,"`
	`3307`	`+appendPQExpBuffer(chkquery,"SELECT conname,"`
`3308`	`3308`	`"pg_catalog.pg_get_constraintdef(oid) AS consrc "`
`3309`	`3309`	`"FROM pg_catalog.pg_constraint "`
`3310`	`3310`	`"WHERE contypid = '%s'::pg_catalog.oid",`
`3311`	`3311`	`tinfo->oid);`
`3312`	`3312`	`else`
`3313`		`-appendPQExpBuffer(chkquery,"SELECT conname, 'CHECK (' \|\| consrc \|\| ')'"`
	`3313`	`+appendPQExpBuffer(chkquery,"SELECT conname, 'CHECK (' \|\| consrc \|\| ')' AS consrc"`
`3314`	`3314`	`"FROM pg_catalog.pg_constraint "`
`3315`	`3315`	`"WHERE contypid = '%s'::pg_catalog.oid",`
`3316`	`3316`	`tinfo->oid);`
`@@ -5267,8 +5267,8 @@ dumpOneTable(Archive fout, TableInfo tbinfo, TableInfo *g_tblinfo)`
`5267`	`5267`	`if (g_fout->remoteVersion >=70400)`
`5268`	`5268`	`appendPQExpBuffer(query,"SELECT conname, "`
`5269`	`5269`	`" pg_catalog.pg_get_constraintdef(c1.oid) AS consrc "`
`5270`		`-" from pg_catalog.pg_constraint c1"`
`5271`		`-" where conrelid = '%s'::pg_catalog.oid "`
	`5270`	`+" from pg_catalog.pg_constraint c1"`
	`5271`	`+" where conrelid = '%s'::pg_catalog.oid "`
`5272`	`5272`	`" and contype = 'c' "`
`5273`	`5273`	`" and not exists "`
`5274`	`5274`	`" (select 1 from "`
`@@ -5286,7 +5286,7 @@ dumpOneTable(Archive fout, TableInfo tbinfo, TableInfo *g_tblinfo)`
`5286`	`5286`	`tbinfo->oid);`
`5287`	`5287`	`elseif (g_fout->remoteVersion >=70300)`
`5288`	`5288`	`appendPQExpBuffer(query,"SELECT conname, "`
`5289`		`-" 'CHECK (' \|\| consrc \|\| ')'"`
	`5289`	`+" 'CHECK (' \|\| consrc \|\| ')' AS consrc"`
`5290`	`5290`	`" from pg_catalog.pg_constraint c1"`
`5291`	`5291`	`" where conrelid = '%s'::pg_catalog.oid "`
`5292`	`5292`	`" and contype = 'c' "`
`@@ -6063,7 +6063,7 @@ dumpConstraints(Archive fout, TableInfo tblinfo, int numTables)`
`6063`	`6063`	`resetPQExpBuffer(query);`
`6064`	`6064`	`appendPQExpBuffer(query,`
`6065`	`6065`	`"SELECT oid, conname, "`
`6066`		`-"pg_catalog.pg_get_constraintdef(oid) as condef "`
	`6066`	`+"pg_catalog.pg_get_constraintdef(oid) as condef "`
`6067`	`6067`	`"FROM pg_catalog.pg_constraint "`
`6068`	`6068`	`"WHERE conrelid = '%s'::pg_catalog.oid "`
`6069`	`6069`	`"AND contype = 'f'",`

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!

Commit9fecf30

File tree

1 file changed

1 file changed

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

0 commit comments