[postgis-devel] Problem with ~/postgresql-8.3-postgis/lwpostgis.sql

[Zico]

On Sun, Aug 30, 2009 at 1:56 AM, Paragon Corporation <lr at pcorp.us> wrote:

>  Zico,
> This is a user question, you should be asking on the PostGIS Users group.
>
> Which version of PostGIS are you trying to install? 1.3 or 1.4
>
> In 1.4 the new file is just called postgis.sql (no longer lwpostgis.sql)
>

Yes, it is postgis.sql


>
> It could be that you are running the 1.3 file  and have postgis-1.4
> .so/.dll loaded.
>
> Check line 6460 of your lwpostgis.sql file to see what that line says.
> Since  that is where it is breaking.
>

Actually... this error is coming from various lines.. as for example:

*psql:/opt/postgis-1.4.0/postgis/postgis.sql:6665: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6703: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6752: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6775: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6781: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6805: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6816: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6821: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6826: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6944: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6949: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
ROLLBACK
*


Here, i want to let you know that, i have changed the permission for that
directory too. I cannot understand what is going on there. :(
-- 
Best,
Zico
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20090830/154c13cb/attachment.html>