Can I ask Postgresql to ignore errors within a transaction
- by fmark
I use Postgresql with the PostGIS extensions for ad-hoc spatial analysis. I generally construct and issue SQL queries by hand from within psql. I always wrap an analysis session within a transaction, so if I issue a destructive query I can roll it back.
However, when I issue a query that contains an error, it cancels the transaction. Any…