[postgis-users] Problems reloading data during hard upgrade

Toomas Aas toomas.aas at raad.tartu.ee
Thu Jan 3 23:33:19 PST 2008


Following the instructions in PostGIS online documentation, I performed a 
hard upgrade from PostGIS 1.1.6 to 1.3.1, at the same time also upgrading 
PostgreSQL from 8.1.5 to 8.2.5. During reloading of databases using 
postgis_restore.pl there were a number of errors recorded in PostgreSQL 
log, which looked like this:

[2-1] ERROR:  current transaction is aborted, commands ignored until end of 
transaction block
[2-2] STATEMENT:  CREATE OR REPLACE FUNCTION spheroid_in(cstring)
[2-3]             RETURNS spheroid
[2-4]             AS '$libdir/liblwgeom.so.1','ellipsoid_in'
[2-5]             LANGUAGE 'C' IMMUTABLE STRICT;

All these errors regard CREATE OR REPLACE FUNCTION statements. As there are 
a lot of them, I haven't verified all functions in all databases, but so 
far all the functions that I have checked actually seem to exist in the 
database. Does this indicate some kind of problem?

Also, the restore log for each database contains two lines beginning with 
KEEPING FUNCTION: [last_pos()]
KEEPING CAST bool,text (see CAST)

The online documentation recommends to check the log for such lines, but 
what I don't understand is - what, if anything, should I do about it?

Toomas Aas

More information about the postgis-users mailing list