[postgis-users] problem with lwpostgis.sql

[??]

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=
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050421/0dec0562/attachment.html>