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 lock
2. Use 'Select ... For Update' (which could be used to lock only the desired
recordsets)
3. Use Exceptions

Any advice / experiences or even pointers would be helpful.

Thanks
Robins Tharakan

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedNov 2, '06 at 12:46p
activeNov 2, '06 at 11:51p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Benjamin Minshall: 1 post Robins: 1 post

People

Translate

site design / logo © 2021 Grokbase