From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Cc: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
Subject: | Back-branch bugs with fully-prunable UPDATEs |
Date: | 2019-04-06 20:27:59 |
Message-ID: | 20710.1554582479@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2019-04-06 20:52:42 | Re: 2019-03 Starts Tomorrow |
Previous Message | Tom Lane | 2019-04-06 19:27:47 | Re: Fix foreign key constraint check for partitioned tables |