diff options
| author | Joe Conway <mail@joeconway.com> | 2015-07-27 20:24:18 -0700 |
|---|---|---|
| committer | Joe Conway <mail@joeconway.com> | 2015-07-27 20:24:18 -0700 |
| commit | e0d4a290f4a24b0a0a46af4d0f8551f8ee5e5513 (patch) | |
| tree | 1452103aa18b44c5425939e657ded4fb054f01c3 /src | |
| parent | 3d5cb31c9a17bad8bbc587c09404b2aa1e6c3aac (diff) | |
| download | postgresql-e0d4a290f4a24b0a0a46af4d0f8551f8ee5e5513.tar.gz postgresql-e0d4a290f4a24b0a0a46af4d0f8551f8ee5e5513.zip | |
Fix pg_dump output of policies.
pg_dump neglected to wrap parenthesis around USING and WITH CHECK
expressions -- fixed. Reported by Noah Misch.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index b24b8bd7c91..00b86766336 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -3012,10 +3012,10 @@ dumpPolicy(Archive *fout, DumpOptions *dopt, PolicyInfo *polinfo) appendPQExpBuffer(query, " TO %s", polinfo->polroles); if (polinfo->polqual != NULL) - appendPQExpBuffer(query, " USING %s", polinfo->polqual); + appendPQExpBuffer(query, " USING (%s)", polinfo->polqual); if (polinfo->polwithcheck != NULL) - appendPQExpBuffer(query, " WITH CHECK %s", polinfo->polwithcheck); + appendPQExpBuffer(query, " WITH CHECK (%s)", polinfo->polwithcheck); appendPQExpBuffer(query, ";\n"); |