I'm trying to get going with postgis. I installed it fine using fink
on my Mac OS X laptop; I'm now trying to install it on a Linux server.
This is using ubuntu 8.04, which has the following packages:
* postgresql 8.3
* postgis 1.3.3
* proj 4.6
* gdal 1.4
* geos 2.2.3
all install fine, but when preparing a template postgis database using
lwconfig.sql, I get the following:
[EMAIL PROTECTED]:~$ psql -d template_postgis -f /usr/
share/postgresql-8.3-postgis/lwpostgis.sql
BEGIN
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:44: NOTICE: type
"histogram2d" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:50: ERROR: cache
lookup failed for type 16769
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:56: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
the last line being repeated about 1000 times, for each SQL command in
the file.
If I upgrade to geos 3.0.0, the script gets slightly further, but then
fails with almost the same error message:
[EMAIL PROTECTED]:~$ psql -d template_postgis -f /usr/
share/postgresql-8.3-postgis/lwpostgis.sql
BEGIN
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:44: NOTICE: type
"histogram2d" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:50: NOTICE:
return type histogram2d is only a shell
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:56: NOTICE:
argument type histogram2d is only a shell
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:62: NOTICE:
argument type histogram2d is only a shell
CREATE FUNCTION
CREATE TYPE
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:88: NOTICE: type
"spheroid" is not yet defined
DETAIL: Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:94: ERROR: cache
lookup failed for type 16781
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:100: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
Any ideas what's going wrong, or how it could be fixed?
Toby
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
