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

From: Vinay Banakar <vinay(dot)s(dot)banakar(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg
Date: 2019-09-13 08:53:37
Message-ID: CAE_mzYTQZ25hui2UrfP0Hgj8fOyUAf_cGL0i4-eGC442m2YoVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Right, I might as well have mistaken as it was quite sometime ago.
Sorry for the confusion.

I see
https://github.com/postgres/postgres/commit/7f1f72c44400e6fef3436b05f1ad0f6bacd03d96
is checked in. However, do you suggest I build pg from this master branch
for my bench marking (benchmarking pg with a particular
dataset) or should I wait until the next STABLE release is created (if so
do you have any information on when the next one will be released)?
I will be running this on Ubuntu 16.04 so hope that does not have any
implications.

Thanks
Vinay

On Fri, Sep 13, 2019, 9:59 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Vinay Banakar <vinay(dot)s(dot)banakar(at)gmail(dot)com> writes:
> > 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.
>
> Oh! I misread your report as being that it worked on 9.5.x and failed
> on 9.6.x. If it really did work on some earlier 9.5.x version, then
> we must've busted it with a patch ... but what? That bizarre code in
> ExecEvalWholeRowVar is much older than 9.5 (looks like it dates to
> 8e617e29a), and the mistake proper goes back to the introduction of
> WITH CHECK OPTION in 9.4 (4cbe3ac3e). I'm not seeing any other
> moving parts here.
>
> regards, tom lane
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-09-13 11:59:24 Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg
Previous Message RUIZ Sébastien 2019-09-13 08:28:08 RE: BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty