Re: LISTEN considered dangerous - Mailing list pgsql-general

From Roman Neuhauser
Subject Re: LISTEN considered dangerous
Date
Msg-id 20060802182329.GA11947@dagan.sigpipe.cz
Whole thread Raw
In response to Re: LISTEN considered dangerous  (Flemming Frandsen <ff@partyticket.net>)
Responses Re: LISTEN considered dangerous
List pgsql-general
# ff@partyticket.net / 2006-08-02 07:57:55 +0200:
> I'm bothered by listen listening from the end of the transaction in
> stead of the start of the transaction.

    Sorry if this isn't what you're after, instead just a question:

    Why don't you issue the LISTEN in a separate transaction before
    going on?

    LISTEN foo;
    BEGIN;
    SELECT ...

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: Best Procedural Language?
Next
From: Tom Lane
Date:
Subject: Re: Where do Tcl questions go?