| From: | Jan Poslusny <pajout(at)gingerall(dot)cz> |
|---|---|
| To: | 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:00:57 |
| Message-ID: | 42088DD9.2010306@gingerall.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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.
> ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Venkatesh Babu | 2005-02-08 10:13:09 | Re: Update command too slow |
| Previous Message | Russell Smith | 2005-02-08 09:11:39 | Re: Sorting when "*" is the initial character |