Re: Allow LISTEN on patterns
Aleksander Alekseev <aleksander@timescale.com>
From: Aleksander Alekseev <aleksander@timescale.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Quan Zongliang <quanzongliang@yeah.net>
Date: 2025-03-05T14:03:46Z
Lists: 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