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
>
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 |