[postgis-users] RC2 is Out

[strk at refractions.net]

On Thu, Jan 27, 2005 at 10:45:31AM +0100, Markus Schaber wrote:
> Hi, Ron,
> 
> strk at refractions.net schrieb:
> >>Would we need a dump/restore to go from RC1 to RC2?
> > 
> > You can avoid it if you drop and recreate
> > all *FromWKB() and *FromText() functions.
> > 
> > Another change in the .sql enabler is a more correct use of
> > IMMUTABLE, STRICT and STABLE keywords, but keeping the
> > old definitions doesn't hurt much.
> 
> If you have several databases to update, the easiest way may be to use
> an edited copy of lwpostgis.sql.
> 
> Simply remove (or comment out) the BEGIN; and COMMIT; lines (line 19 and
> 3186 in my version 1.108), and ignore the error messages.
> 
> All function definitions are replaced, and everything else gives an
> error message. So it works fine as long as the only things that actually
> change are functions. Types and operators may be added, but not change.
> 
> This "Quick and Dirty" hack worked for me several times, but your
> mileage may vary.

In this case this would *add* *FromWKB(bytea) and *FromText(text)
but would *not remove* *FromWKB(geometry) and *FromText(geometry),
which would end up being broken. You still need to drop the
old ones.

Anyway, that's a good tip.

--strk;

> 
> HTH,
> markus
> 
> -- 
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios at logi-track.com | www.logi-track.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users