1--
2-- ASYNC
3--
4
5--Should work. Send a valid message via a valid channel name
6SELECT pg_notify('notify_async1','sample message1');
7SELECT pg_notify('notify_async1','');
8SELECT pg_notify('notify_async1',NULL);
9
10-- Should fail. Send a valid message via an invalid channel name
11SELECT pg_notify('','sample message1');
12SELECT pg_notify(NULL,'sample message1');
13SELECT pg_notify('notify_async_channel_name_too_long______________________________','sample_message1');
14
15--Should work. Valid NOTIFY/LISTEN/UNLISTEN commands
16NOTIFY notify_async2;
17LISTEN notify_async2;
18UNLISTEN notify_async2;
19UNLISTEN *;
20
21-- Should return zero while there are no pending notifications.
22-- src/test/isolation/specs/async-notify.spec tests for actual usage.
23SELECT pg_notification_queue_usage();
24