On 16 Dec 2010, at 18:13, [email protected] wrote: > Hello, > I'm having a problem running an update command that invokes a trigger, the > problem is that the function performed takes about 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 cause dead-locks with your update (e.g. they aren't directly connected), then you can use LISTEN/NOTIFY to notify another process 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! -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
