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

From Christopher Kings-Lynne
Subject Re: ALTER TABLE TODO items
Date
Msg-id 409AEB60.1010503@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 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.

Seems reasonable.

> 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.

Yeah, I was thinking along those lines.  I don't now though...

What happens with ordering of operations in the ALTER TABLE statement? 
Like if I put an alter TYPE and a SET STORAGE in the same statement 
(wiht commas between), in what order will things happen?  Is it 
deterministic?  Is it documented?  Are there situations where a crazy 
collection of 20 commands in a single ALTER TABLE will have 
unpredictable effects?

Also, should the syntax be SET TYPE, not just TYPE?

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: psql 7.3.4 disagrees with NATURAL CROSS JOIN
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE TODO items