Re: more RLS oversights - Mailing list pgsql-hackers

From Joe Conway
Subject Re: more RLS oversights
Date
Msg-id 55B6F706.7070608@crunchydata.com
Whole thread Raw
In response to Re: more RLS oversights  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
On 07/03/2015 10:03 AM, Noah Misch wrote:
>> +static void
>> +dumpPolicy(Archive *fout, PolicyInfo *polinfo)
> ...
>> +    if (polinfo->polqual != NULL)
>> +        appendPQExpBuffer(query, " USING %s", polinfo->polqual);
> 
> (3) The USING clause needs parentheses; a dump+reload failed like so:

Also needed for WITH CHECK. Fix pushed to 9.5 and HEAD.

Joe





pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: multiple psql option -c
Next
From: Tom Lane
Date:
Subject: Re: Failing assertions in indxpath.c, placeholder.c and brin_minmax.c