Re: ALTER TABLE TODO items - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: ALTER TABLE TODO items
Date
Msg-id 409ADB00.5060506@familyhealth.com.au
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ALTER TABLE TODO items  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> I tweaked things so that the clustered flag is preserved for indexes
> that aren't directly affected by the ALTER TYPE.  It would take more
> work to preserve the setting for an index that is rebuilt by ALTER TYPE,
> and I'm not even sure that it's sensible --- the new index could have
> a significantly different ordering from the old.  What do you think?

Out of interest what happens to other column features such as the 
existing statistics level and the existing storage spec?  I guess these 
might have to change when type changes??

Chris


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: alter table alter columns vs. domains
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE TODO items