Expose Notification Listener

[wolframm]

Is there a way to access a connection and listen to its notifications directly from a PgPool instance?

I have a worker app that listens to various notification tasks and also updates the database when a task is done. At the moment I am using one PgPool instance plus a separate connection initialized using the postgres package.

final connection = PostgreSQLConnection(...);
connection.notifications.listen((event) async {
    if (event.channel == _taskName) await _sendEmails();
  });

final pool = PgPool(...);
await pool.execute('listen $_taskName;');

Please kindly provide a brief example if this is possible already.

[isoos]

I think at the moment this is the best approach, as there is no direct API support for such thing. It is a different kind of load that is expected from such notification listener connection, so maybe in the future, PgPool could provide the connection itself, but right now it doesn't.