Stopping a transaction as soon as an error occurs

Hi list,

I am dumping a series of data. Basically I'm migrating the tables from one
database to another. However, I wanted the transaction to stop immediately
as soon as the error below occurs:

psql:gravy.all.schema.sql:142136: ERROR: current transaction is aborted,
commands ignored until end of transaction block

What happens is that it continues to do the transaction even if there's
already a transaction and I'm having hard time catching it. I need to know
which line number the error first occured so that I can check my dump file
and do the necessary remedy.


Thanks,

Ridvan