[postgis-users] PostGIS 1.5.4 Released

Tue May 8 14:03:34 PDT 2012

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 at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users