[postgis-users] problem with lwpostgis.sql

Thu Apr 21 07:20:16 PDT 2005

On Thu, Apr 21, 2005 at 04:12:29PM +0200, Jean David TECHER wrote:
> Hi
> 
> As Sandro said the most important think is the first ERROR U had...
> 
> When U did configure did U do
> 
> a complete configure???
> 
> cd postgis-1.0.0 (I supposed U are i PGSRL_SRC/contrib)
> 
> ./configure --with-geos=/usr/local/bin/geos-config --with-proj=/usr/local
> --enable-autoconf

David, please don't advertise untested ways of configuring postgis ;)
I mean, not w/out saying it's untested (remove the --enable-autoconf
from your suggestion so users will be automatically warned!).

--strk;

> 
> See the stdout did by configure to see if Geos and Proj are OK...
> 
> An other possibility is to check that your DB didn't exist before ...
> ---------------------------------------------------------------
> TECHER Jean David
> 01MAP
> e-mail: david at 01map.net
> Tél: 04 67 45 60 27
> Entreprise: http://www.01map.net
> Perso: http://techer.pascal.free.fr/postgis/
> ---------------------------------------------------------------
> ----- Original Message -----
> From: "Godwin, Elizabeth" <Godwinl at AGR.GC.CA>
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Sent: Thursday, April 21, 2005 3:11 PM
> Subject: RE: [postgis-users] problem with lwpostgis.sql
> 
> 
> 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
> >
> _______________________________________________
> 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