>       EXCEPTION WHEN unique_violation THEN

I seem to remember that catching an exception in a PL/pgSQL procedure was a 
large performance cost.   It'd be better to do UPDATE ... IF NOT FOUND.


Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to