[postgis-users] Problem installing postgis

[strk]

On Tue, Mar 16, 2010 at 10:46:58AM -0700, loldrup2 wrote:
> 
> Hi
> 
> I just installed postgresql-8.3-postgis and postgis .DEB-packages in Ubuntu
> 9.10 following this guide:
> http://trac.osgeo.org/postgis/wiki/UsersWikiPostgisOnUbuntu
> 
> Now I'm following the 'Using PostGIS'-part. Step 2 tells me to set up the
> PostGIS libs by entering this:
> psql -d mytestdb -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql 
> 
> It gives me a load of error messages, all like this:
> psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:6531: ERROR:  current
> transaction is aborted, commands ignored until end of transaction block
> 
> finishing off with: ROLLBACK
> 
> In the Linux-shell I am logged into the postgres-account.
> What could I be doing wrong?

Redirect output and error to a file and you'll see what went wrong
by reading that file (first ERROR line).

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html