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 <dbhandary@xxxxxxxxxxxx> 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 value into unique index column was called at the same time. I even
check if the value exist before inserting, but one of the instance of the
function gave me an unique constraint violation error.
My code looks like this:
select into var * from table;
if not found then
insert into table
values (a);
end if;
|
I would imagine the postgres db would inherently handle situation like this,
but it did not.
Thanks.
See http://www.postgresql.org/docs/8.3/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING,
specifically example Example 38-1.