Re: LISTEN considered dangerous - Mailing list pgsql-general

From Harald Fuchs
Subject Re: LISTEN considered dangerous
Date
Msg-id pu8xm7gxfa.fsf@srv.protecting.net
Whole thread Raw
In response to LISTEN considered dangerous  (Flemming Frandsen <ff@partyticket.net>)
Responses Re: LISTEN considered dangerous  (Flemming Frandsen <ff@partyticket.net>)
List pgsql-general
In article <44D0478D.3060201@partyticket.net>,
Flemming Frandsen <ff@partyticket.net> writes:

>> I would still expect any
>> reimplementation of notify messaging to honor the principle that a
>> LISTEN doesn't take effect till you commit.

> Naturally, the listen should not do anything at all when followed by a
> rollback.

> However if you start listening in a transaction then you should get
> all events that have happened after the snapshot that the transaction
> represents (the start of the transaction).

Here you're contradicting yourself.  In your second paragraph you
state that LISTEN should get events unless later cancelled by a
ROLLBACK.  How should LISTEN know if its transaction will commit or
abort?

pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: when do pg_temp SCHEMAS get purged?
Next
From: Tom Lane
Date:
Subject: Re: LISTEN considered dangerous