Support LISTEN/NOTIFY in transaction mode

[levkk]

Description

LISTEN/NOTIFY are session-level features that could be supported in transaction mode. Possible implementation:

• Intercept both commands
• Use dedicated connection to execute both commands
• Listen for NotificationResponse (B) messages from connection and fan out to interested clients

Docs: https://www.postgresql.org/docs/current/sql-listen.html