Re: more RLS oversights

From: Joe Conway <joe(dot)conway(at)crunchydata(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: more RLS oversights
Date: 2015-07-28 03:29:10
Message-ID: 55B6F706.7070608@crunchydata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-07-28 03:31:44 Re: Failing assertions in indxpath.c, placeholder.c and brin_minmax.c
Previous Message Pavel Stehule 2015-07-28 03:24:35 Re: proposal: multiple psql option -c