[postgis-users] Errors upgrading from 1.4.0 to 1.5.2

David Cato otac at crunchyfrog.net
Sat Oct 30 23:14:23 PDT 2010


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




More information about the postgis-users mailing list