[ gpsdrive ] postgresql & postgis integration
Chris H
chris123 at magma.ca
Thu Jun 5 20:12:42 AKDT 2008
Greets:
Following the tutorial submitted by info at 4x4falcon.com and on the same system
I repeated have run into the same error. The instruction is not wrong rather
there is something that I am missing as a previous instruction set produced
the same errors. Specifically when issuing the command:
"$> psql -d gis -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql" as user
postgres the line always barfs for me. The result is
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:6269: ERROR: current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:6307: ERROR: current
transaction is aborted, commands ignored until end of transaction block
until 6430 at which time psql issues the command "ROLLBACK" As Ive had the
same error testing on both postgresql 8.2 and 8.3 its time to ask for help in
tracking down the source of this problem.
If anyone has any insights on where I should start, it would be appreciated.
Fired off the same question to the postgis list as well late this evening.
Best and thanks
--
/ch
More information about the GPSdrive
mailing list