On 9/6/06, Jean-Christophe Praud <[EMAIL PROTECTED]> wrote:
Hi all,
I'm planning to convert an application to postgresql 8.1 (from mysql).
Currently we have some recursive procedures done on the application side
we would want to rewrite as stored pl/pgsql procedures called by triggers...
Is it possible for these triggers to be asynchronous, in order not to
block the client application during the recursive process ?
Have you considered doing the recursion on the server side?
http://people.planetpostgresql.org/merlin/index.php?/archives/2-Dealing-With-Recursive-Sets-With-PLPGSQL.html
merlin
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
