[postgis-users] problem with lwpostgis.sql

[strk at refractions.net]

The interesting part of the error is the initial one, the first ERROR
is meaningful, the other just says an error occurred before and thus
every command is ignored.
--strk;

On Thu, Apr 21, 2005 at 02:54:20PM +0800, ?? wrote:
> 
> Hi!
>  
> when  install postgis 1.0.0,
> 
> $createlang plpgsql test (ok,test is mydatabase)
> 
> $psql -f lwpostgis.sql -d test (this is not ok)
> 
> part of error message:
> -------------------------------error message-----------------------------
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3008: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3013: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3018: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3024: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3029: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3034: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3039: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3044: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3052: ERROR:  current transaction is aborted, commands ignored until end of transac
> tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3057: ERROR:  current transaction is aborted, commands ignored until end of transac                      tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3062: ERROR:  current transaction is aborted, commands ignored until end of transac                      tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3071: ERROR:  current transaction is aborted, commands ignored until end of transac                      tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3077: ERROR:  current transaction is aborted, commands ignored until end of transac                      tion block
> ERROR:  current transaction is aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:3083: ERROR:  current transaction is aborted, commands ignored until end of transac                      tion block
> ROLLBACK
> -------------------------
> 
> 
> whereis wrong ?How do? Please help me,thanks very much!
> 
> 
> 
> 
> The following is how i  install postgis :
> 
> 
> tar zxvf postgis-1.0.0.tar.gz
> 
> copy postgis-1.0.0 to path/postgresql-8.0.1/contrib
> 
> cd path /postgresql-8.0.1/contrib (the following operation all in this DIR)
> 
> #LDFLAGS=-lstdc++ ./configure --enable-autoconf --with-geos=

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users