<br><br><div class="gmail_quote">On Sun, Aug 30, 2009 at 1:56 AM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>Zico,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial" size="2"><span>This is a user question, you should be asking on the
PostGIS Users group.</span></font></div>
<div><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div><font color="#0000ff" face="Arial" size="2"><span>Which
version of PostGIS are you trying to install? 1.3 or
1.4</span></font></div>
<div><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div><font color="#0000ff" face="Arial" size="2"><span>In 1.4
the new file is just called postgis.sql (no longer
lwpostgis.sql)</span></font></div></div></blockquote><div><br>Yes, it is postgis.sql<br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div><font color="#0000ff" face="Arial" size="2"><span></span></font></div>
<div><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div><font color="#0000ff" face="Arial" size="2"><span>It
could be that you are running the 1.3 file and have postgis-1.4 .so/.dll
loaded.</span></font></div>
<div><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div><font color="#0000ff" face="Arial" size="2"><span>Check
line 6460 of your lwpostgis.sql file to see what that line says.
Since that is where it is breaking.</span></font></div></div></blockquote><div><br>Actually... this error is coming from various lines.. as for example:<br><br><i>psql:/opt/postgis-1.4.0/postgis/postgis.sql:6665: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6703: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>psql:/opt/postgis-1.4.0/postgis/postgis.sql:6752: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6775: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>psql:/opt/postgis-1.4.0/postgis/postgis.sql:6781: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6805: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>psql:/opt/postgis-1.4.0/postgis/postgis.sql:6816: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6821: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>psql:/opt/postgis-1.4.0/postgis/postgis.sql:6826: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
psql:/opt/postgis-1.4.0/postgis/postgis.sql:6944: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>psql:/opt/postgis-1.4.0/postgis/postgis.sql:6949: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
ROLLBACK<br></i></div></div><br><br>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. :(<br>-- <br>Best,<br>Zico<br>