NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit0484175

committed

Fix pg_get_constraintdef to cope with NOT VALID constraints

This case was missed when NOT VALID constraints were first introduced incommit722bf70 by Simon Riggs on2011-02-08. Among other things, it causes pg_dump to omit the NOT VALIDflag when dumping such constraints, which may cause them to fail toload afterwards, if they contained values failing the constraint.Per report from Thom Brown.

1 parentea8e42f commit0484175Copy full SHA for 0484175

File tree

1 file changed

-0

lines changed

src/backend/utils/adt
- ruleutils.c

1 file changed

-0

lines changed

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

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1373,6 +1373,9 @@ pg_get_constraintdef_worker(Oid constraintId, bool fullCommand,`
`1373`	`1373`	`if (conForm->condeferred)`
`1374`	`1374`	`appendStringInfo(&buf," INITIALLY DEFERRED");`
`1375`	`1375`
	`1376`	`+if (!conForm->convalidated)`
	`1377`	`+appendStringInfoString(&buf," NOT VALID");`
	`1378`	`+`
`1376`	`1379`	`/* Cleanup */`
`1377`	`1380`	`ReleaseSysCache(tup);`
`1378`	`1381`

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!

Commit0484175

File tree

1 file changed

1 file changed

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

0 commit comments