From: | Shaun Clements <ShaunC(at)relyant(dot)co(dot)za> |
---|---|
To: | 'Jan Poslusny' <pajout(at)gingerall(dot)cz>, Surabhi Ahuja <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2005-02-08 10:51:25 |
Message-ID: | B16D6764833DA442961BBD8CC1AF7CFD01E033A1@srldbexc003.relyant.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You would need to use EXCEPTION, to trap the error.
Kind Regards,
Shaun Clements
-----Original Message-----
From: Jan Poslusny [mailto:pajout(at)gingerall(dot)cz]
Sent: 08 February 2005 12:01 PM
To: Surabhi Ahuja
Cc: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
Subject to www.relyant.co.za/edisclaim.htm
From | Date | Subject | |
---|---|---|---|
Next Message | Clodoaldo Pinto | 2005-02-08 11:06:38 | Re: Out of memory error |
Previous Message | Christoph Pingel | 2005-02-08 10:50:28 | indexing just a part of a string |