[postgis-users] RC2 is Out

Markus Schaber schabios at logi-track.com
Thu Jan 27 01:45:31 PST 2005

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.


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

More information about the postgis-users mailing list