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

[Zico]

On Sun, Aug 30, 2009 at 8:23 PM, Zico <mailzico at gmail.com> wrote:

>
>
> 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*
>

[ ... ]

Ok, solved it anyway.

We have to make sure that /usr/local/lib is added to /etc/ld.so.conf and
after that you run /sbin/ldconfig

That`s it!


-- 
Best,
Zico
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20090830/5a9bcdf6/attachment.html>