Horton

Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg

Vinay Banakar <vinay.s.banakar@gmail.com>

View thread View on postgr.es
From: Vinay Banakar <vinay.s.banakar@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>, pgsql-bugs@lists.postgresql.org
Date: 2019-09-13T04:13:21Z
Lists: pgsql-bugs 
Hello,

Thank you for finding the root cause, I just checked on 9.15.17 and it is
still failing here also.
But I distinctly remember it working earlier, not sure which version of pg
(at least <9.5.16) though as I have lost that earlier setup.

Regards
Vinay

On Fri, Sep 13, 2019 at 3:58 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Andres Freund <andres@anarazel.de> writes:
> > I don't quite understand how this "visibly" broke between 9.5.15 and
> > 9.5.19 as the op reports? Haven't dug into it yet though.
>
> I'm confused about that too, since in my hands the submitted test
> case fails in both of those branches.  I've also been able to
> adapt it to fail in v10/v11.  Will commit in a moment.
>
>                         regards, tom lane
>

Commits

  1. Fix usage of whole-row variables in WCO and RLS policy expressions.