Re: BUG #15631: Generated as identity field in a temporary table withon commit drop corrupts system catalogs - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #15631: Generated as identity field in a temporary table withon commit drop corrupts system catalogs
Date
Msg-id e5017903-059f-35f1-6f8e-84401bf90f91@2ndquadrant.com
Whole thread Raw
In response to Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs  (Michael Paquier <michael@paquier.xyz>)
Responses Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
On 2019-03-09 02:35, Michael Paquier wrote:
> On Fri, Mar 08, 2019 at 12:00:40PM +0100, Peter Eisentraut wrote:
>> OK, let's go with this.  Attached is your patch with my comment wording.
> 
> Thanks for double-checking.  Your change looks fine to me.
> 
>>  Also a test case, but I don't suggest committing that, it's a bit too
>> weird.  (The effect of the test is to cause catalog corruption that will
>> cause a later test to fail.)  We can leave it in the archive for posterity.
> 
> Letting the test case out is fine for me too.

I looked into backpatching this, but the test case doesn't fail in PG10.
 I ran a round of bisecting but didn't arrive at a sensible result.  The
test case appears to be a bit random in its failure modes.  The issue
could in principle extend further back, since the code in question isn't
really new.  Any ideas or suggestions?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15685: pg_upgrade fails to migrate DEFAULT values that use custom TYPEs or FUNCTIONs
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs