On Fri, Apr 01, 2005 at 05:52:49AM +0200, Enrico Weigelt wrote: > is it possible somehow to make (AFTER) triggers run in their > own process/thread, so the calling session can return immediately > and the trigger runs in background ?
Not really, though you could signal an external process to do something asynchronously using LISTEN/NOTIFY. That is, unless you write your trigger function in C and it calls fork(). Not sure if that would actually work though (and you should forget about accessing the database.) -- Alvaro Herrera (<[EMAIL PROTECTED]>) "Estoy de acuerdo contigo en que la verdad absoluta no existe... El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
