Asynchronous trigger

From: Jean-Christophe Praud <jc(at)praud(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Asynchronous trigger
Date: 2006-09-06 21:29:18
Message-ID: 44FF3DAE.5050406@praud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arturo Perez 2006-09-06 21:56:28 Problems with sequences
Previous Message SebaM 2006-09-06 21:08:32 inet/cidr type ?!