"Marc Mamin" <[EMAIL PROTECTED]> writes: > Can I optimize this function with:
> a) remove the EXCEPTION clause (Is there an underlying lock that prevent > concurrent inserts ?) No. > b) declare the function being IMMUTABLE ? Certainly not --- it's got side-effects. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org