Re: BUG #15446: Crash on ALTER TABLE - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #15446: Crash on ALTER TABLE
Date
Msg-id 20190105170940.2qrbilpxmmxyf4tr@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #15446: Crash on ALTER TABLE  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: BUG #15446: Crash on ALTER TABLE  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
List pgsql-bugs
Hi,

On 2019-01-05 12:11:45 +0000, Dean Rasheed wrote:
> It looks like the problem was introduced in PG11 by 16828d5c02 (Fast
> ALTER TABLE ADD COLUMN with a non-NULL default). The first ALTER TABLE
> adds a new column with a non-null default, setting atthasmissing and
> attmissingval. Then the second ALTER TABLE changes the type of the new
> column, but it fails to update attmissingval to match, and thus it
> falls over when trying to re-open the relation because the value in
> attmissingval is no longer compatible with the attribute type.

Paging Dr Dunstan.

Greetings,

Andres Freund


pgsql-bugs by date:

Previous
From: Phil Hildebrand
Date:
Subject: Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound
Next
From: PG Bug reporting form
Date:
Subject: BUG #15577: Query returns different results when executed multipletimes