Re: Database transaction related

Thanks alot john.
that was helpful

On 5/14/07, John D. Burger <john(at)mitre(dot)org> 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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>