Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15247: At 'ALTER TABLE ADD COLUMN fast default' , Set attmissingval to NULL in the pg_attribute, query fail - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #15247: At 'ALTER TABLE ADD COLUMN fast default' , Set attmissingval to NULL in the pg_attribute, query fail
Date
Msg-id 87d0wnqta9.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to BUG #15247: At 'ALTER TABLE ADD COLUMN fast default' ,Set attmissingval to NULL in the pg_attribute, query fail  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15247: At 'ALTER TABLE ADD COLUMN fast default' , Set attmissingval to NULL in the pg_attribute, query fail  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
>>>>> "PG" == PG Bug reporting form <noreply@postgresql.org> writes:

 PG> (4)  update pg_attribute set attmissingval = NULL where attname = 'b';

Nobody ever claimed that you could update pg_attribute without crashing
the server; I can think of half a dozen ways to do it.

-- 
Andrew (irc:RhodiumToad)

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15247: At 'ALTER TABLE ADD COLUMN fast default' , Setattmissingval to NULL in the pg_attribute, query fail
Next
From: Michael Paquier
Date:
Subject: Re: When pg_rewind success, the database can't startup