On 16 Dec 2010, at 18:13, felipe@informidia.com.br wrote:
> Hello,
> I'm having a problem running an update command that invokes a trigger, the problem is that the function performed
takesabout 45 minutes to finish and my application is locked waiting for the finish.
> You know how I can't wait for the end?
As usual, that depends. If running that function asynchronously from your update can not break referential integrity or
causedead-locks with your update (e.g. they aren't directly connected), then you can use LISTEN/NOTIFY to notify
anotherprocess on a different connection that the function should be performed.
Alban Hertroys
--
Screwing up is an excellent way to attach something to the ceiling.
!DSPAM:737,4d1473b6802655198511903!