Hello!
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:
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
