Re: - Mailing list pgsql-general

From Shaun Clements
Subject Re:
Date
Msg-id B16D6764833DA442961BBD8CC1AF7CFD01E033A1@srldbexc003.relyant.co.za
Whole thread Raw
In response to  ("Surabhi Ahuja " <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general

You would need to use EXCEPTION, to trap the error.

Kind Regards,
Shaun Clements

-----Original Message-----
From: Jan Poslusny [mailto:pajout@gingerall.cz]
Sent: 08 February 2005 12:01 PM
To: Surabhi Ahuja
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly
Subject to www.relyant.co.za/edisclaim.htm

pgsql-general by date:

Previous
From: Christoph Pingel
Date:
Subject: indexing just a part of a string
Next
From: Clodoaldo Pinto
Date:
Subject: Re: Out of memory error