Stopping a transaction as soon as an error occurs - Mailing list pgsql-novice

From Ridvan Lakas ng Bayan S. Baluyos
Subject Stopping a transaction as soon as an error occurs
Date
Msg-id 7f4f9efa0807162149g1dd78caenf111961196f7a64a@mail.gmail.com
Whole thread Raw
Responses Re: Stopping a transaction as soon as an error occurs
List pgsql-novice
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


--
Laurence J. Peter  - "Originality is the fine art of remembering what you hear but forgetting where you heard it."

pgsql-novice by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Two novice questions
Next
From: John DeSoi
Date:
Subject: Re: Stopping a transaction as soon as an error occurs