Thanks alot john. that was helpful On 5/14/07, John D. Burger <[EMAIL PROTECTED]> wrote:
Jasbinder Singh Bali wrote: > could you please elaborate this concept of queue table? The basic idea is to for the insert trigger to not explicitly kick off the work you need to have done, but simply insert a row into a "work request table". A separate process notices that there is a work request, and performs the work. This can be done by a periodic cron job, or using NOTIFY/LISTEN. There was a fairly detailed discussion of this last month - the thread starts here: http://archives.postgresql.org/pgsql-general/2007-04/msg01152.php - John D. Burger MITRE ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly