[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-devel
Subject:    Re: [postgis-devel] In-place upgrade to 2.0
From:       Mark Cave-Ayland <mark.cave-ayland () siriusit ! co ! uk>
Date:       2011-05-31 9:12:41
Message-ID: 4DE4B109.6050002 () siriusit ! co ! uk
[Download RAW message or body]

On 24/05/11 16:30, Paul Ramsey wrote:

> yes, my scheme was going to be to two-step by first creating
> GEOMETRY2, then altering all the columns to that (by maintaining an
> lwgeom handler to do the cast from serialized_form to gserialized),
> then creating GEOMETRY and altering all the columns to that. Which
> would work fine for data-only databases, but installations with more
> complex constructions (views, triggers) expecting 'geometry' input
> arguments might balk if I alter their column types underneath them.
>
> P.

GEOMETRY2? That sounds very Oracle-esque... ;)


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
_______________________________________________
postgis-devel mailing list
postgis-devel@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel
[prev in list] [next in list] [prev in thread] [next in thread]