From: | Noah Misch <noah(at)leadboat(dot)com> |
---|---|
To: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Smolkin Grigory <smallkeen(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz> |
Subject: | Re: race condition in pg_class |
Date: | 2024-07-14 17:48:00 |
Message-ID: | 20240714174800.de.nmisch@google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Jul 04, 2024 at 03:08:16PM -0700, Noah Misch wrote:
> On Thu, Jul 04, 2024 at 08:00:00AM +0300, Alexander Lakhin wrote:
> > 28.06.2024 08:13, Noah Misch wrote:
> > > Pushed. ...
> >
> > Please look also at another anomaly, I've discovered.
> >
> > An Assert added with d5f788b41 may be falsified with:
> > CREATE TABLE t(a int PRIMARY KEY);
> > INSERT INTO t VALUES (1);
> > CREATE VIEW v AS SELECT * FROM t;
> >
> > MERGE INTO v USING (VALUES (1)) AS va(a) ON v.a = va.a
> > WHEN MATCHED THEN DO NOTHING
> > WHEN NOT MATCHED THEN DO NOTHING;
> >
> > TRAP: failed Assert("resultRelInfo->ri_TrigDesc"), File: "nodeModifyTable.c", Line: 2891, PID: 1590670
>
> Thanks. When all the MERGE actions are DO NOTHING, view_has_instead_trigger()
> returns true
I've pushed the two patches for your reports. To placate cfbot, I'm attaching
the remaining patches.
Attachment | Content-Type | Size |
---|---|---|
inplace090-LOCKTAG_TUPLE-eoxact-v8.patch | text/plain | 1.2 KB |
inplace110-successors-v8.patch | text/plain | 44.7 KB |
inplace120-locktag-v8.patch | text/plain | 43.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michail Nikolaev | 2024-07-14 18:01:50 | [BUG?] check_exclusion_or_unique_constraint false negative |
Previous Message | Alexander Lakhin | 2024-07-14 16:00:00 | Re: Internal error codes triggered by tests |