Postgres Pro
Downloads
Home   >   mailing lists

Re: LISTEN considered dangerous - Mailing list pgsql-general

From Tom Lane
Subject Re: LISTEN considered dangerous
Date
Msg-id 14672.1154522729@sss.pgh.pa.us
Whole thread Raw
In response to Re: LISTEN considered dangerous  (Flemming Frandsen <ff@partyticket.net>)
Responses Re: LISTEN considered dangerous  (Oisin Glynn <me@oisinglynn.com>)
Re: LISTEN considered dangerous  (Flemming Frandsen <ff@partyticket.net>)
List pgsql-general
Tree view 
Flemming Frandsen <ff@partyticket.net> writes:
> The listen should simply listen for events issued at the start of the
> transaction it's executed in.

    BEGIN;
    SELECT sleep(1000000000);
    LISTEN foo;

No, I don't think so.

            regards, tom lane

pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: LISTEN considered dangerous
Next
From: Tom Lane
Date:
Subject: Re: Strange error message