Horton

Re: BUG #17151: A SEGV in optimizer

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: 253540651@qq.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2021-08-19T16:13:31Z
Lists: pgsql-bugs 
Masahiko Sawada <sawada.mshk@gmail.com> writes:
> On Thu, Aug 19, 2021 at 8:24 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> We probably need some regression test cases added (I wonder whether
>> FOR UPDATE in rule actions is covered at all ATM).  Otherwise
>> I feel like this is OK to commit.

> +1 for adding at least two queries reported on this thread to regression tests.

Right, pushed with some test cases.

			regards, tom lane

Commits

  1. Avoid trying to lock OLD/NEW in a rule with FOR UPDATE.