[postgis-devel] In-place upgrade to 2.0

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Mon May 23 01:49:55 PDT 2011

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?



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

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

More information about the postgis-devel mailing list