I'm trying to upgrade PostGIS from 1.4.0 to 1.5.2 but am encountering
errors in the postgis_upgrade_14_to_15.sql script. When run, I get
... trimmed output ...
psql:postgis_upgrade_14_to_15.sql:219: NOTICE: type "box3d_extent" is not yet
defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:postgis_upgrade_14_to_15.sql:223: NOTICE: argument type box3d_extent is
only a shell
CREATE FUNCTION
psql:postgis_upgrade_14_to_15.sql:227: NOTICE: argument type box3d_extent is
only a shell
CREATE FUNCTION
psql:postgis_upgrade_14_to_15.sql:231: NOTICE: argument type box3d_extent is
only a shell
CREATE FUNCTION
psql:postgis_upgrade_14_to_15.sql:235: NOTICE: argument type box3d_extent is
only a shell
... trimmed output ...
psql:postgis_upgrade_14_to_15.sql:1262: NOTICE: argument type box3d_extent is
only a shell
psql:postgis_upgrade_14_to_15.sql:1262: NOTICE: return type box3d_extent is
only a shell
CREATE FUNCTION
psql:postgis_upgrade_14_to_15.sql:1266: NOTICE: argument type box3d_extent is
only a shell
psql:postgis_upgrade_14_to_15.sql:1266: NOTICE: return type box3d_extent is
only a shell
CREATE FUNCTION
DROP AGGREGATE
psql:postgis_upgrade_14_to_15.sql:1272: ERROR: type "box3d_extent" is only a
shell
psql:postgis_upgrade_14_to_15.sql:1273: ERROR: current transaction is aborted,
commands ignored until end of transaction block
... another 625 transaction aborted messages ...
The failure occurs on the first CREATE AGGREGATE statement:
CREATE AGGREGATE Extent(
sfunc = ST_combine_bbox,
basetype = geometry,
stype = box3d_extent
);
I'm running this with PostgreSQL 8.4 on a Linux system, if that makes
any difference.
How can I fix the problem and complete the upgrade?
--
David Cato
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
