[postgis-users] problem with lwpostgis.sql

Godwin, Elizabeth Godwinl at AGR.GC.CA
Thu Apr 21 06:11:42 PDT 2005


I had a similar problem.  My linux admin said he ran "ldconfig -v" as
root

That fixed it.

Liz

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of strk at refractions.net
> Sent: April 21, 2005 4:56 AM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] problem with lwpostgis.sql
> 
> 
> 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
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



More information about the postgis-users mailing list