Never mind! the problem is because the upgrade scripts are not schema
aware. I keep all my data in the "data" schema and have the database
search_path set to "data, public" and when I last upgraded from 1.3.3 to
1.5.3 it dumped all the functions into the "data" schema creating a
mess. So now I probably just need to dump tables for about 50 databases
and rebuild the databases from the dumps. <sigh> I think this probably
need to be put off until I can upgrade to 9.x and 2.0 on a new server.
-Steve
On 5/8/2012 4:00 PM, Stephen Woodbridge wrote:
I'm trying to install and upgrade a database with the new 1.5.4 version
ad I'm getting an error.
I did the ./configure; make; sudo make install which all went well
psql -U postgres -h localhost testdb
testdb=# select * from postgis_full_version();
postgis_full_version
-----------------------------------------------------------------------------------------------------------------------------------------
POSTGIS="1.5.4" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August
2008" LIBXML="2.6.32" USE_STATS (procs from 1.5 r7360 need upgrade)
(1 row)
testdb=# set search_path to public, pg_catalog;
SET
testdb=# \i postgis_upgrade_15_minor.sql
BEGIN
CREATE FUNCTION
postgis_major_version_check
------------------------------------------
Scripts versions checked for upgrade: ok
(1 row)
DROP FUNCTION
CREATE FUNCTION
CREATE FUNCTION
...
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:220: NOTICE: type "box3d_extent" is
not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:224: NOTICE: argument type
box3d_extent is only a shell
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:228: NOTICE: argument type
box3d_extent is only a shell
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:232: NOTICE: argument type
box3d_extent is only a shell
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:236: NOTICE: argument type
box3d_extent is only a shell
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
...
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:1263: NOTICE: argument type
box3d_extent is only a shell
psql:postgis_upgrade_15_minor.sql:1263: NOTICE: return type box3d_extent
is only a shell
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:1267: NOTICE: argument type
box3d_extent is only a shell
psql:postgis_upgrade_15_minor.sql:1267: NOTICE: return type box3d_extent
is only a shell
CREATE FUNCTION
psql:postgis_upgrade_15_minor.sql:1268: NOTICE: aggregate
extent(geometry) does not exist, skipping
DROP AGGREGATE
psql:postgis_upgrade_15_minor.sql:1273: ERROR: type "box3d_extent" is
only a shell
psql:postgis_upgrade_15_minor.sql:1274: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1279: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1283: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1287: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1288: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1293: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1294: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1299: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1302: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:postgis_upgrade_15_minor.sql:1305: ERROR: current transaction is
aborted, commands ignored until end of transaction block
...
psql:postgis_upgrade_15_minor.sql:5161: ERROR: current transaction is
aborted, commands ignored until end of transaction block
ROLLBACK
testdb=# select postgis_full_version();
postgis_full_version
-------------------------------------------------------------------------------------
POSTGIS="1.3.3" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August
2008" USE_STATS
(1 row)
Is the upgrade script broken? How can I fix this?
Thanks,
-Steve
On 5/6/2012 6:41 AM, Paul Ramsey wrote:
Download from:
http://postgis.org/download/postgis-1.5.4.tar.gz
The news:
This is a bug fix release, addressing issues that have been
filed since the 1.5.3 release.
- Bug Fixes
- #547, ST_Contains memory problems (Sandro Santilli)
- #621, Problem finding intersections with geography (Paul Ramsey)
- #627, PostGIS/PostgreSQL process die on invalid geometry (Paul Ramsey)
- #810, Increase accuracy of area calculation (Paul Ramsey)
- #852, improve spatial predicates robustness (Sandro Santilli,
Nicklas Avén)
- #877, ST_Estimated_Extent returns NULL on empty tables (Sandro
Santilli)
- #1028, ST_AsSVG kills whole postgres server when fails (Paul Ramsey)
- #1056, Fix boxes of arcs and circle stroking code (Paul Ramsey)
- #1135, improve testsuite predictability (Andreas 'ads' Scherbaum)
- #1146, images generator crashes (bronaugh)
- #1170, North Pole intersection fails (Paul Ramsey)
- #1179, ST_AsText crash with bad value (kjurka)
- #1184, honour DESTDIR in documentation Makefile (Bryce L Nordgren)
- #1227, server crash on invalid GML
- #1252, SRID appearing in WKT (Paul Ramsey)
- #1264, st_dwithin(g, g, 0) doesn't work (Paul Ramsey)
- #1344, allow exporting tables with invalid geometries (Sandro Santilli)
- #1389, wrong proj4text for SRID 31300 and 31370 (Paul Ramsey)
- #1406, shp2pgsql crashes when loading into geography (Sandro Santilli)
- #1595, fixed SRID redundancy in ST_Line_SubString (Sandro Santilli)
- #1596, check SRID in UpdateGeometrySRID (Mike Toews, Sandro Santilli)
- #1602, fix ST_Polygonize to retain Z (Sandro Santilli)
- #1697, fix crash with EMPTY entries in GiST index (Paul Ramsey)
- #1772, fix ST_Line_Locate_Point with collapsed input (Sandro Santilli)
- #1799, Protect ST_Segmentize from max_length=0 (Sandro Santilli)
- Alter parameter order in 900913 (Paul Ramsey)
- Support builds with "gmake" (Greg Troxel)
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
