<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18294" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009>Zico,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009>This is a user question, you should be asking on the
PostGIS Users group.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=206315019-29082009>Which
version of PostGIS are you trying to install? 1.3 or
1.4</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=206315019-29082009>In 1.4
the new file is just called postgis.sql (no longer
lwpostgis.sql)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=206315019-29082009>It
could be that you are running the 1.3 file and have postgis-1.4 .so/.dll
loaded.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=206315019-29082009>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><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=206315019-29082009>Hope
that helps,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=206315019-29082009>Regina</SPAN></FONT></DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-devel-bounces@postgis.refractions.net
[mailto:postgis-devel-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Zico<BR><B>Sent:</B> Saturday, August 29, 2009 1:37 PM<BR><B>To:</B> PostGIS
Development Discussion<BR><B>Subject:</B> [postgis-devel] Problem with
~/postgresql-8.3-postgis/lwpostgis.sql<BR></FONT><BR></DIV>
<DIV></DIV>Hi, <BR clear=all>I hv been trying to run this command :
psql -U postgres -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
fixmystreet<BR>But.. I am facing this
error:<BR><B>psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:6460:
ERROR: current transaction is aborted, commands ignored until end of
transaction block<BR></B><BR>I cannot understand this error. Can you help
me?<BR><BR>-- <BR>Best,<BR>Zico<BR></BODY></HTML>