[postgis-users] Input on upgrade to GIS database

Markus Schaber schabi at logix-tt.com
Fri Nov 18 09:29:09 PST 2005


Hi, Jeremy,

Sears, Jeremy schrieb:

> I suspect the errors were due to the fact that the db that the dump came
> from had written geometry functions in along with the data, when I loaded
> the data into a new db that already had these functions, PostgreSQL put up
> some fuss. 

So I'd think that your old dump has replaced some of the new definitions
with their old ones. You can try to replay the new lwpostgis.sql
(possibly with removed transaction encapsulation) and hope the best, but
I'd guarantee for nothing.

Markus



More information about the postgis-users mailing list