Re: [PERFORM] Locking vs. Exceptions

2006-11-02 Thread Benjamin Minshall
Robins wrote: Hi, The documentation says that function blocks with exceptions are far costlier than without one. I recommend against using exceptions. There is a memory leak in the exception handler that will cause headaches if it is called many times in the transaction. In plpgsql, I

[PERFORM] Locking vs. Exceptions

2006-11-02 Thread Robins
Hi,The documentation says that function blocks with exceptions are far costlier than without one.So if I need to implement an INSTEAD OF trigger (after checking for unique constraint violations) which way should I go ? 1. Get a table lock2. Use 'Select ... For Update' (which could be used to lock o