Great. That's what I was looking for. Thanks a lot guys.
Dinesh
Alex Hunsaker wrote:
On Tue, Jun 10, 2008 at 2:46 PM, Dinesh <[EMAIL PROTECTED]> wrote:
Hi Scott,
Thanks for your reply.
Is there a built in exception in pl/pgsql ( similar to oracle's
|DUP_VAL_ON_INDEX ) that I can use?
I r
On Tue, Jun 10, 2008 at 2:46 PM, Dinesh <[EMAIL PROTECTED]> wrote:
> Hi Scott,
>
> Thanks for your reply.
>
> Is there a built in exception in pl/pgsql ( similar to oracle's
> |DUP_VAL_ON_INDEX ) that I can use?
>
> I ran into an unique situation a couple of days ago. Procedure that inserts
> a new
Hi Scott,
Thanks for your reply.
Is there a built in exception in pl/pgsql ( similar to oracle's
|DUP_VAL_ON_INDEX ) that I can use?
I ran into an unique situation a couple of days ago. Procedure that
inserts a new value into unique index column was called at the same
time. I even check if
On Tue, Jun 10, 2008 at 10:52 AM, Dinesh <[EMAIL PROTECTED]> wrote:
> 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 w
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 don
