From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-hackers@lists.postgresql.org
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Subject: Back-branch bugs with fully-prunable UPDATEs
Date: Sat, 06 Apr 2019 16:27:59 -0400
Message-ID: <20710.1554582479@sss.pgh.pa.us> (raw)
This test script works fine in HEAD:
drop table if exists parttbl cascade;
CREATE TABLE parttbl (a int, b int) PARTITION BY LIST (a);
CREATE TABLE parttbl_1 PARTITION OF parttbl FOR VALUES IN (NULL,500,501,502);
UPDATE parttbl SET a = NULL, b = NULL WHERE a = 1600 AND b = 999;
In v11, it suffers an assertion failure in ExecSetupPartitionTupleRouting.
In v10, it doesn't crash, but we do get
WARNING: relcache reference leak: relation "parttbl" not closed
which is surely a bug as well.
(This is a boiled-down version of the script I mentioned in
https://www.postgresql.org/message-id/13344.1554578481@sss.pgh.pa.us)
This seems to be related to what Amit Langote complained of in
https://www.postgresql.org/message-id/21e7eaa4-0d4d-20c2-a1f7-c7e96f4ce440@lab.ntt.co.jp
but since there's no foreign tables involved at all, either it's
a different bug or he misdiagnosed what he was seeing.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org, Langote_Amit_f8@lab.ntt.co.jp
Subject: Re: Back-branch bugs with fully-prunable UPDATEs
In-Reply-To: <20710.1554582479@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox