postgres.git / summary / log / commit / refs

commit    510aad31eaf2129d28ae3dbfc58f98775192ee94
Author:   Joe Conway <mail@joeconway.com>
Date:     Tue Jul 28 03:24:27 2015 +0000

    Fix pg_dump output of policies.
    
    pg_dump neglected to wrap parenthesis around USING and WITH CHECK
    expressions -- fixed. Reported by Noah Misch.


 src/bin/pg_dump/pg_dump.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 0b5262a8a1a..ba1497fed49 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");
 


[parent: 5d179a28fb4c]