[postgis-users] 1.2.0 Release

[Greg Troxel]

I am updating pkgsrc for the new version, and having trouble updating
my database (which has no useful contents):

BEGIN
CREATE FUNCTION
psql:/usr/pkg/share/postgresql/contrib/lwpostgis_upgrade.sql:38: ERROR:  could not access file "/usr/pkg/lib/liblwgeom.so.1.1": No such file or directory
CONTEXT:  SQL statement "SELECT  postgis_lib_version()"
PL/pgSQL function "postgis_major_version_check" line 19 at select into variables
psql:/usr/pkg/share/postgresql/contrib/lwpostgis_upgrade.sql:40: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/usr/pkg/share/postgresql/contrib/lwpostgis_upgrade.sql:44: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/usr/pkg/share/postgresql/contrib/lwpostgis_upgrade.sql:48: ERROR:  current transaction is aborted, commands ignored until end of transaction block

pkgsrc removed the .1.1 version because it was in the old pkg, and now
it's .1.2:

> l /usr/pkg/lib/liblwg*
lrwxr-xr-x  1 root  wheel      16 Dec  9 09:53 /usr/pkg/lib/liblwgeom.so -> liblwgeom.so.1.2
lrwxr-xr-x  1 root  wheel      16 Dec  9 09:53 /usr/pkg/lib/liblwgeom.so.1 -> liblwgeom.so.1.2
-rwxr-xr-x  1 root  wheel  895661 Dec  9 09:53 /usr/pkg/lib/liblwgeom.so.1.2


I can see why this is hard to work around, but it seems correct of
packaging systems to remove old shlibs.

Perhaps the version that's in the db should be stored in the db, and
checked there?