> On Dec 20, 2024, at 2:58 PM, Tom Lane wrote:
> Seems reasonable in the abstract, and given the UNLISTEN * precedent
> it's hard to quibble with that syntax choice. I think what actually
> needs discussing are the semantics, specifically how this'd interact
> with other LISTEN/UNLISTEN actions
Choosing 'LISTEN *' has a nice symmetry with
'UNLISTEN
*', but I don't have enough SQL chops to know if it cause problems.
If anyone has a better work-around, please speak up! If not, and we can come to
some
resolution on a future-resistant syntax, I'd happily start working up a patch
set.
Thanks,
-- Trey Boudreau
> On Dec 20, 2024, at 4:07 PM, Tom Lane wrote:
>
> Hmph. After thinking about it a bit I have a different idea
> (and I see David has yet a third one). So maybe this is more
> contentious than it seems. But at any rate, I have two
> fundamental thoughts:
>
> * "Listen to all but X" seems lik
> On Dec 20, 2024, at 4:45 PM, Tom Lane wrote:
>
> "David G. Johnston" writes:
>> On Friday, December 20, 2024, Tom Lane wrote:
>>> * "Listen to all but X" seems like a reasonable desire.
>
>> This I concur with, and would add: let me name my channels
>> accounting.payables, accounting.recei
Based on [1], please find attached an implementation for listeningfor notifications on all channels. The first two chunks lay somegroundwork and do not change the current LISTEN behavior, exceptto improve performance of managing large numbers of channels.v1-0001-Make-simplehash-more-flexible.patch
> On Mar 3, 2025, at 10:39 PM, Quan Zongliang wrote:
>
> I implemented a LISTEN command that supports matching names in the LIKE
> format.
>
> Just like
>
> LISTEN 'c%';
> NOTIFY c1;NOTIFY c2;
>
> Notifications are received for c1 and c2.
>
The parser down-cases ColId. Thus:
LISTEN MiXeD
> On Mar 5, 2025, at 10:42 AM, Tom Lane wrote:
>
> Anyway, I encourage reading some of the past threads on this
> topic.
>
I didn’t see any past references to the pg_notify() ‘anomaly’:
LISTEN FOO;
NOTIFY FOO, ‘BAR’; -- notification delivered
PERFORM pg_notify(‘FOO’, ‘BAR’); -- notification N
