Capture the start of the log and the first statement that fails. Below is just repeating that there was an initial failure and it is not executing more statements within this transaction. For example I've often found aborts caused by inadequate permissions, in which case something like -u <db owner> can be required.<div>
<br><div><br><div class="gmail_quote">On 16 May 2010 21:26, arnauld ndefo <span dir="ltr"><<a href="mailto:ndefo2002@yahoo.fr">ndefo2002@yahoo.fr</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font:inherit"><div>Hi everybody,<br>i am a new developer who use a mapnik to build my own
map. I use Window instead of ubuntu.I want to know how to install
postgis on windows?<br>when i do "psql -d gis -f "c:\Program
Files\PostgreSQL\8.3\share\co<br>ntrib\lwpostgis.sql" on my windows command
shell i have this list of error: <br><br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4858: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4864: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4870: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4876: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4882: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4888: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4894: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4900: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4906: ERROR: c<br>urrent
transaction is aborted, commands
ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4912: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4918: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4923: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4928: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4933: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4938:
ERROR: c<br>urrent transaction is aborted, commands ignored until end
of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4948: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4958: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4968: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4979: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4989: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction
block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4999: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5009: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5019: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5025: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5031: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5041: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5051: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5061: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5071: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5077: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5083: ERROR: c<br>urrent
transaction is aborted, commands ignored until end of transaction block<br><br>I
don't know how to result this
problem, please help me<br><br>thank you<br><br><br><br><br>Ndefo Kamgne Arnauld<br>
Cité Ettayour,Immeuble Bolbol 1,Appartement A2,Ariana<br>
0021624249357</div></td></tr></tbody></table><br>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div></div>