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

From Tom Lane
Subject Re: ALTER TABLE TODO items
Date
Msg-id 26548.1083890737@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE TODO items  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: ALTER TABLE TODO items  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> 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??

I left the statistic setting as-is (do you think that's wrong?) but the
storage spec gets reset to whatever the default for the new type is.
We could talk about doing something more complicated, such as "keep the
old setting if both old and new types support toasting, else reset to
new default".  Not sure if that'd be better or not.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: ALTER TABLE TODO items
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] cast not IMMUTABLE?