Hi List, working on grass65 svn, with the "pg" dbms driver, I am trying to run several slq statements from a shell script. These statements are generated within a loop and I would like them to be executed in a transaction. I see it might not be possible this way :
echo "BEGIN TRANSACTION;" | db.execute echo "myfirststatement;" | db.execute echo "mysecondstatement" | db.execute ... echo "COMMIT;" | db.execute as it returns WARNING: there is no transaction in progress Should I dump all the commands in a temporary file $tmp then run db.execute input=$tmp ? or is there a better way ? Thank you, Vincent. _______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user