[postgis-devel] In-place upgrade to 2.0
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