Re: BUG #15720: `executor could not find named tuplestore ABC` in AFTER DELETE trigger referencing OLD TABLE as ABC

From: Jason Madden <jason(dot)madden(at)nextthought(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15720: `executor could not find named tuplestore ABC` in AFTER DELETE trigger referencing OLD TABLE as ABC
Date: 2019-07-09 15:55:38
Message-ID: 276540DF-C02E-44A4-A042-E0F245EC3129@nextthought.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On Jul 9, 2019, at 10:45, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>
> FYI, we're now thinking that the problem here is unrelated to partitions
> but instead is a bug in EPQ, which is a subsystem that's entered only when
> a row to be locked/updated is found to have just been updated by some
> concurrent transaction. See
>
> https://www.postgresql.org/message-id/flat/15900-bc482754fe8d7415%40postgresql.org
>
> If you're in a position to build a custom version of Postgres, you
> might try whether the patch proposed in that thread resolves your
> problem.

Thank you for the update. Unfortunately, I no longer work with that system and aren't able to try to reproduce the issue.

~Jason

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-07-09 17:07:18 Re: ALTER TABLE results in "ERROR: could not open relation with OID 43707388"
Previous Message Tom Lane 2019-07-09 15:45:02 Re: BUG #15720: `executor could not find named tuplestore ABC` in AFTER DELETE trigger referencing OLD TABLE as ABC