Commite0d4a29

committed

Fix pg_dump output of policies.

pg_dump neglected to wrap parenthesis around USING and WITH CHECKexpressions -- fixed. Reported by Noah Misch.

1 parent3d5cb31 commite0d4a29Copy full SHA for e0d4a29

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -3012,10 +3012,10 @@ dumpPolicy(Archive fout, DumpOptions dopt, PolicyInfo *polinfo)`
`3012`	`3012`	`appendPQExpBuffer(query," TO %s",polinfo->polroles);`
`3013`	`3013`
`3014`	`3014`	`if (polinfo->polqual!=NULL)`
`3015`		`-appendPQExpBuffer(query," USING%s",polinfo->polqual);`
	`3015`	`+appendPQExpBuffer(query," USING(%s)",polinfo->polqual);`
`3016`	`3016`
`3017`	`3017`	`if (polinfo->polwithcheck!=NULL)`
`3018`		`-appendPQExpBuffer(query," WITH CHECK%s",polinfo->polwithcheck);`
	`3018`	`+appendPQExpBuffer(query," WITH CHECK(%s)",polinfo->polwithcheck);`
`3019`	`3019`
`3020`	`3020`	`appendPQExpBuffer(query,";\n");`
`3021`	`3021`

Comments

(0)