Re: BUG #13988: "plan should not reference subplan's variable" whilst using row level security

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Adam Guthrie <asguthrie(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13988: "plan should not reference subplan's variable" whilst using row level security
Date: 2016-02-29 12:57:37
Message-ID: CAEZATCVQyxHHzaqbKaP4L-3=g1W+XDk+OPcrW=kv+FWM_Rtvyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 26 February 2016 at 08:27, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
> I just did a quick test, and setting newvar->varlevelsup to 0 does
> indeed appear to fix the reported problem, and the SB views variant of
> it.
>

OK, confirmed. That was a pretty clear-cut bug in the updatable
security barrier views code.

Fix pushed to master and backpatched to 9.4.

Thanks for the report.

Regards,
Dean

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Сергей Кочетков 2016-02-29 13:30:19 Prepared statements
Previous Message Thom Brown 2016-02-29 10:55:40 Re: Server crash with certain encodings