Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hksaG-0005BF-Tr for pgsql-bugs@arkaria.postgresql.org; Tue, 09 Jul 2019 16:03:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hksaF-0008RK-PQ for pgsql-bugs@arkaria.postgresql.org; Tue, 09 Jul 2019 16:03:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hksT2-0005km-Lp for pgsql-bugs@lists.postgresql.org; Tue, 09 Jul 2019 15:55:44 +0000 Received: from mail-ot1-x341.google.com ([2607:f8b0:4864:20::341]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hksSz-0008VN-UL for pgsql-bugs@lists.postgresql.org; Tue, 09 Jul 2019 15:55:44 +0000 Received: by mail-ot1-x341.google.com with SMTP id n5so1961133otk.1 for ; Tue, 09 Jul 2019 08:55:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nextthought-com.20150623.gappssmtp.com; s=20150623; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=xAbHwnJztc3GwnPjuAsax4en9F4Vi+BSPGmF1NDyIJY=; b=oAFFTczpBcgNdg6mqs6lRAr0zOgSciV6BqeDqghdFSm4zhx9g2A/46W7LpdcCwCqO/ ogajYbX1ep7/AZuOfQODxagPesPp+VJX7/+uXQUgf3AINTK2sSk5tYNWLWpf5i6pm8jv ed7pV/yPEhY/ZkF09n8HvhyJVXfD6qU8b1gGrqlTe5lqJhfVhtxhIbER6Iof/hgdNcJC l4t01rNaoYWnqG7HxHvxVSEiOr4KCW8lk1KOwurNDBm8/eL7GY+HAw7NwnIFYBuEg1Kh QhRCmbs2aBRZ29wE5vDEwu1dOV2swCogOXTub59V4c5NK9XIVTWa1YrJ+ZJr3oH4xOh4 IKgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=xAbHwnJztc3GwnPjuAsax4en9F4Vi+BSPGmF1NDyIJY=; b=bvavPFb31+JIbhh0SqHTc6O6i3bdduPTUT7b0bdSd6JZQEK9OKtGK0t7F5FueOpbxi gaNcqAwY73rlKyvQzKZqlojKMIygbx8XGDwy3Uw3MFNUOvpaif+ajllZk/oISIN0a3/G lv5+Af09ENySZgZ9S+4B5/I8x5uoCG1SFPRGSSPst7XWYH6y10reYHD3Cw5DWLi5mREw gVC1wv4XoEKmEKtcGkw7AnV/dEkukPK9v2r2Cb9d2Z7ol/otiHa4ONkLeRwmF6Q1WCE8 Y6Sq6wO6k/bGI/+td0oxsf4BMKzgs10g9ZiYjP7m/7axs3vfXzbbU+AH0dWT1MnC+/O6 EAuA== X-Gm-Message-State: APjAAAVtDecIzfhPtTwUGy+wolpPOL/X6kmYxCKuekrfDmJgPUV7mlIU UC4bspSIX2UNtGfPbV0aSvR5LQ== X-Google-Smtp-Source: APXvYqwDe9OZV/xiwEjqFROTw70e1C6Z6+z8DVdo5Dbb81U9kilU0IkqjscL6TAk2MnNhqdwJhG3pw== X-Received: by 2002:a9d:19cc:: with SMTP id k70mr19853843otk.304.1562687740009; Tue, 09 Jul 2019 08:55:40 -0700 (PDT) Received: from [192.168.1.82] (104-63-220-66.lightspeed.okcbok.sbcglobal.net. [104.63.220.66]) by smtp.gmail.com with ESMTPSA id y184sm6337659oie.33.2019.07.09.08.55.39 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 09 Jul 2019 08:55:39 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.11\)) Subject: Re: BUG #15720: `executor could not find named tuplestore ABC` in AFTER DELETE trigger referencing OLD TABLE as ABC From: Jason Madden In-Reply-To: <24823.1562687102@sss.pgh.pa.us> Date: Tue, 9 Jul 2019 10:55:38 -0500 Cc: Thomas Munro , PostgreSQL mailing lists Content-Transfer-Encoding: quoted-printable Message-Id: <276540DF-C02E-44A4-A042-E0F245EC3129@nextthought.com> References: <15720-38c2b29e5d720187@postgresql.org> <27B30574-291E-4C33-B89F-B690FB6CA492@nextthought.com> <24823.1562687102@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3445.104.11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > On Jul 9, 2019, at 10:45, Tom Lane wrote: >=20 >=20 > 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 >=20 > = https://www.postgresql.org/message-id/flat/15900-bc482754fe8d7415%40postgr= esql.org >=20 > 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=