TPgConnection.OnNotification Event

Occurs when an asynchronous notification is received from PostgreSQL server.

Class

TPgConnection

Syntax

property OnNotification: TPgNotificationEvent;

Remarks

The OnNotification event occurs when an asynchronous notification is received from PostgreSQL server. Notification can be sent using NOTIFY command. To receive notifications use LISTEN command. To stop receiving notifications use UNLISTEN command. You can read more information about these commands in the PostgreSQL documentation.

Note: Notifications can be received only when a call to the server is performed (for example, on executing SQL statement). While the connection is idle, notifications are not received. To receive notifications while the connection is idle, use the TPgAlerter component.