Re: [PATCH] Space reservation v02

Robert Haas wrote:
> People who upgrade via pg_dump will automatically get the new and
> improved widget type because that is what is now called widget.  But
> people who in-place upgrade will end up with the old_shitty_widget
> type.  Then you just run some dead simple postupdate script that goes
> through and issues ALTER TABLE commands to change each
> old_shitty_widget column to a widget column.

Altering column type with ALTER TABLE needs to exclusively-lock and 
rewrite the whole table, so you might as well pg_dump+restore that table.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com