NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitd31b20a

committed

Fix dumping of DEFERRABLE/INITIALLY DEFERRED:

> The big problem is that while pg_dump's dump_trigger() looks at> tginitdeferred and dumps accordingly, pg_get_constraintdef doesn't look> at tginitdeferred, and therefore doesn't record the requirement as part> of ALTER TABLE ADD CONSTRAINT.pg_get_constraintdef should probably be looking at condeferrable andcondeferred in the pg_constraint row it's looking at. Maybe somethinglike the attached.(Added, output only non-default values.)Stephan Szabo

1 parent5e36cbe commitd31b20aCopy full SHA for d31b20a

File tree

1 file changed

-1

lines changed

src/backend/utils/adt
- ruleutils.c

1 file changed

-1

lines changed

`‎src/backend/utils/adt/ruleutils.c`

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`*back to source text`
`4`	`4`	`*`
`5`	`5`	`* IDENTIFICATION`
`6`		`- * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.129 2002/12/14 00:17:59 tgl Exp $`
	`6`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.130 2003/01/08 22:54:06 momjian Exp $`
`7`	`7`	`*`
`8`	`8`	`* This software is copyrighted by Jan Wieck - Hamburg.`
`9`	`9`	`*`
`@@ -688,6 +688,11 @@ pg_get_constraintdef(PG_FUNCTION_ARGS)`
`688`	`688`	`}`
`689`	`689`	`appendStringInfo(&buf," ON DELETE %s",string);`
`690`	`690`
	`691`	`+if (conForm->condeferrable)`
	`692`	`+appendStringInfo(&buf," DEFERRABLE");`
	`693`	`+if (conForm->condeferred)`
	`694`	`+appendStringInfo(&buf," INITIALLY DEFERRED");`
	`695`	`+`
`691`	`696`	`break;`
`692`	`697`	`}`
`693`	`698`

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!

Commitd31b20a

File tree

1 file changed

1 file changed

`‎src/backend/utils/adt/ruleutils.c`

0 commit comments