public inbox for [email protected]  

help / color / mirror / Atom feed

From: Paul Jungwirth <[email protected]>
To: Peter Eisentraut <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: jian he <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: vignesh C <[email protected]>
Subject: Re: SQL:2011 application time
Date: Wed, 12 Feb 2025 09:14:10 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<5f0c25de-2c13-4fb5-a4df-a1e03c43cd14@illuminatedcomputin! g.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On 2/12/25 07:23, Peter Eisentraut wrote:
> I committed your patch on Sunday, and now it's about 72 hours later.
> 
> I've been observing this on cfbot for some time.  Before the patch, you could go to cfbot at any 
> time and find between 5 and 10 test failures from this problem.  And now there are none.  So I'm 
> calling provisional success on this.

That's great! It's sort of unsatisfying though---and unnerving. I wish when the test failed we knew 
what the oids were for the RESTRICT constraint and the just-dropped NO ACTION constraint. (There's 
no way to get that after the fact, is there?) I probably won't keep putting time into this, but it 
seems like there must still be a hard-to-hit bug in the code for caching query plans. Since the 
behavior disappeared, it is more evidence that that's where the real problem lies.

Yours,

-- 
Paul              ~{:-)
[email protected]

view thread (23+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: SQL:2011 application time
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox