cant the same be done by
trapping the errors. by trapping these exceptions?
search for "trapping errors" ?
Sent: Tue 2/8/2005 3:30 PM
To: Surabhi Ahuja
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
***********************
Your mail has been scanned by
InterScan VirusWall.
***********-***********
You can use
savepoints in pg 8.0:
http://www.postgresql.org/docs/8.0/static/sql-savepoint.html
Surabhi
Ahuja wrote:
> in a transaction i try to insert into a table1,
followed by insert
> into table 2 then insert into table 3 and last insert
into table 4.
> However if a unique key violation occurs in the table 1 ,
the whole
> trabnsaction aborts. is there no way , where i can ignore
this
> violation, and continue with the remaining insertions.
>
?
