Re:

["Surabhi Ahuja " <surabhi.ahuja@xxxxxxxxxxx>]

Title: Re:

cant the same be done by trapping the errors. by trapping these exceptions? 

http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-structures.html

 

search for "trapping errors" ?

---

From: Jan Poslusny 
[mailto:pajout@xxxxxxxxxxxx]
Sent: Tue 2/8/2005 3:30 PM
To: 
Surabhi Ahuja 
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:

***********************
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.
> ?