error handling unique key constraint in pgsql

From: Dinesh <dbhandary(at)mongonet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: error handling unique key constraint in pgsql
Date: 2008-06-10 16:52:27
Message-ID: 484EB14B.4010003@mongonet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

I was wondering if there is an easy way to handle unique key constraint
in pgsql. Right now my entire transaction aborts if it tries to insert
duplicate keys, but I would like to handle this
scenario in such a way that the transaction will not break.

Please let me know if you have done something like this. I greatly
appreciate your help.

Thanks,

Dinesh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Travis Smith 2008-06-10 16:54:02 Re: Cannot Drop Schema
Previous Message Scott Marlowe 2008-06-10 15:52:29 Re: postgres 'forgets' table definitions