Re: Discussion on a LISTEN-ALL syntax - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: Discussion on a LISTEN-ALL syntax
Date
Msg-id 4ad7140c-04e2-4b5f-aef7-3497c7ccecb4@postgresfriends.org
Whole thread Raw
In response to Re: Discussion on a LISTEN-ALL syntax  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 21/12/2024 05:23, Tom Lane wrote:
> Vik Fearing <vik@postgresfriends.org> writes:
>> Could I perhaps propose a sort of wildmat[1] syntax?
>> The above sequence could be expressed simply as:
>>       LISTEN *,!foo.*,foo.bar.*
> That doesn't absolve you from having to say what happens if the
> user then issues another "LISTEN zed" or "UNLISTEN foo.bar.baz"
> command.  We can't break the existing behavior that "LISTEN foo"
> followed by "LISTEN bar" results in listening to both channels.
> So on the whole this seems like it just adds complexity without
> removing any.  I'm inclined to limit things to one pattern per
> LISTEN/UNLISTEN command, with more complex behaviors reached
> by issuing a sequence of commands.


Fair enough.

-- 

Vik Fearing




pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: Fix logging for invalid recovery timeline
Next
From: Pavel Stehule
Date:
Subject: Re: Add XMLNamespaces to XMLElement