[postgis-devel] In-place upgrade to 2.0

[Mark Cave-Ayland]

On 21/05/11 10:56, Paul Ramsey wrote:

> The mechanism is the same for everyone, the 9.1 users just get it
> "automagically" with a SQL command and everyone else has to (quell
> horror!) run a .sql file.
>
> Though now that I think about it in the clear light of early morning
> there's lots of ways my scheme will fail, so perhaps not.

I thought that in-place upgrade only works if the binary formats are 
unchanged? So if we change LWGEOM -> G_GEOMETRY then this isn't going to 
work. Or does the extension upgrade execute an ALTER COLUMN statement to 
rebuild the column anyway?


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs