Add PostgreSQL LISTEN/NOTIFY notification listening
- Status
- Fixed
- Fixed in
- v26.9.2
- Area
- -
- Source discussion
- https://forum.objo.dev/d/1044-feature-request-postgresql-listennotify
- Last updated
- 2026-09-16
Upvotes
0 upvotes
Uses your Objo forum account.
Public summary
Add PostgreSQL LISTEN/NOTIFY support to Objo so apps can receive asynchronous PostgreSQL notifications.
Users who build on PostgreSQL's LISTEN/NOTIFY need a way to subscribe to notification channels and receive notifications while the app runs. Sending notifications already works through the existing database API (NOTIFY or pg_notify() via ExecuteSQL/SelectSQL), but receiving them is not possible today.
A new PostgreSQLNotificationListener class would open its own dedicated PostgreSQL connection, subscribe to one or more channels, and raise an event on the VM thread for each notification received, with the channel name, payload, and sender process ID. Connection details would follow the existing PostgreSQLDatabase conventions (connection string or host/port/database/user/password, Timeout), and connection failures would be reported through an error event with DatabaseException details.