On 9/6/06, Jean-Christophe Praud <jc@xxxxxxxxx> 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
