[postgis-users] Failing: psql -d [yourdatabase] -f lwpostgis.sql

[Matthew Perry]

Adam,

 You may have to add the plpgsql language to your database first:

  createlang -d [yourdatabase] plpgsql

- matt

On 12/29/06, Adam <adam at spatialsystems.org> wrote:
>
>
> I'm installing version 1.1.6 and everything is fine until the step:
>
> psql -d [yourdatabase] -f lwpostgis.sql
>
> It's all erroring out.  Any idea what the problem is or where I go to see
> what the error is?
>
> psql:lwpostgis.sql:3368: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:lwpostgis.sql:3375: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:lwpostgis.sql:3380: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:lwpostgis.sql:3385: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:lwpostgis.sql:3444: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:lwpostgis.sql:3462: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:lwpostgis.sql:3509: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> ROLLBACK
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>


-- 
Matthew T. Perry
GIS Analyst / Software Engineer
National Center for Ecological Analysis and Synthesis (NCEAS)
work: perry at nceas.ucsb.edu
web: http://www.perrygeo.net