On 2025/3/4 23:57, Trey Boudreau wrote:
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 Col
On 2025/3/6 00:42, Tom Lane wrote:
Aleksander Alekseev writes:
For instance, if I do:
```
LISTEN aaafoo;
LISTEN aaabar;
UNLISTEN aaa%;
```
Should I:
A. be unsubscribed from aaafoo and aaabar since both match aaa% or
B. UNLISTEN should have no effect since I never subscribed to aaa%
Trey Boudreau writes:
> 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 NOT delivered
> PERFORM pg_notify(‘foo’, ‘BAR’); -- notification delivered
> Can we come to some
Does not seem like a bug to me. Just the normal auto-lowercase encountered
in every other SQL command. See:
greg=# select * from pg_listening_channels();
pg_listening_channels
---
(0 rows)
greg=# listen foo;
LISTEN
greg=# select * from pg_listening_channels();
pg_listening_c
> 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
Aleksander Alekseev writes:
> For instance, if I do:
> ```
> LISTEN aaafoo;
> LISTEN aaabar;
> UNLISTEN aaa%;
> ```
> Should I:
> A. be unsubscribed from aaafoo and aaabar since both match aaa% or
> B. UNLISTEN should have no effect since I never subscribed to aaa% explicitly?
Yeah, the whole
Hi,
> I implemented a LISTEN command that supports matching names in the LIKE
> format.
The overall idea seems reasonable. It would be nice to have such a
feature as long as it doesn't affect the performance of the existing
applications. I think we should discuss particular semantics though.
For
> 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
