| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Space reservation v02 |
| Date: | 2009-01-31 19:44:43 |
| Message-ID: | 4984AA2B.1080808@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2009-01-31 19:56:26 | Re: [PATCH] Space reservation v02 |
| Previous Message | Grzegorz Jaskiewicz | 2009-01-31 17:42:36 | Re: adding stuff to parser, question |