Re: Allow LISTEN on patterns - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Allow LISTEN on patterns
Date
Msg-id CAJ7c6TPaCKsaONXak3VDmvgex7r0-WAk2AJ+YyZyZK=ktCrgfA@mail.gmail.com
Whole thread Raw
In response to Allow LISTEN on patterns  (Quan Zongliang <quanzongliang@yeah.net>)
Responses Re: Allow LISTEN on patterns
List pgsql-hackers
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 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?

Personally I would expect A, but I'm not sure how many people will agree.

-- 
Best regards,
Aleksander Alekseev



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Allow database owners to CREATE EVENT TRIGGER
Next
From: Andres Freund
Date:
Subject: Re: per backend WAL statistics