Asynchronous trigger - Mailing list pgsql-general

From Jean-Christophe Praud
Subject Asynchronous trigger
Date
Msg-id 44FF3DAE.5050406@praud.com
Whole thread Raw
Responses Re: Asynchronous trigger  (Jeff Davis <pgsql@j-davis.com>)
Re: Asynchronous trigger  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Asynchronous trigger  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
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 ?

Regards,


--
Jean-Christophe Praud         -      http://shub-niggurath.com
Conseil & Développement Informatique      http://www.praud.com
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!


pgsql-general by date:

Previous
From: SebaM
Date:
Subject: inet/cidr type ?!
Next
From: Jeff Davis
Date:
Subject: Re: Asynchronous trigger