------=_Part_25974_6866944.1216270157340
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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."
------=_Part_25974_6866944.1216270157340
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
<div dir="ltr">Hi list,<br><br>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:<br>
<br><div style="margin-left: 40px;">psql:gravy.all.schema.sql:142136:
ERROR: current transaction is aborted, commands ignored until end of
transaction block<br><br></div>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. <br>
<br><br>Thanks,<br><br>Ridvan<br><div><br clear="all"><br>-- <br>Laurence
J. Peter - "Originality is the fine art of remembering what you
hear but forgetting where you heard it."
</div></div>
------=_Part_25974_6866944.1216270157340--
|
