NAME

       dblink_get_notify - retrieve async notifications on a connection

SYNOPSIS

       dblink_get_notify() returns setof (notify_name text, be_pid int, extra text)
       dblink_get_notify(text connname) returns setof (notify_name text, be_pid int, extra text)

DESCRIPTION

           Note
           The following description applies only to Postgres-XC

       dblink module has not been tested with Postges-XC yet. Although there're no reason that
       dblink does not run in Postgres-XC, the development team leaves the test and the use of
       this module entirely to users.

       This section is identical to the corresponding PostgreSQL reference manual.

           Note
           The following description applies only to PostgreSQL

       dblink_get_notify retrieves notifications on either the unnamed connection, or on a named
       connection if specified. To receive notifications via dblink, LISTEN must first be issued,
       using dblink_exec. For details see LISTEN(7) and NOTIFY(7).

ARGUMENTS

           Note
           The following description applies only to Postgres-XC

       dblink module has not been tested with Postges-XC yet. Although there're no reason that
       dblink does not run in Postgres-XC, the development team leaves the test and the use of
       this module entirely to users.

       This section is identical to the corresponding PostgreSQL reference manual.

           Note
           The following description applies only to PostgreSQL

       conname
           The name of a named connection to get notifications on.

RETURN VALUE

           Note
           The following description applies only to Postgres-XC

       dblink module has not been tested with Postges-XC yet. Although there're no reason that
       dblink does not run in Postgres-XC, the development team leaves the test and the use of
       this module entirely to users.

       This section is identical to the corresponding PostgreSQL reference manual.

           Note
           The following description applies only to PostgreSQL

       Returns setof (notify_name text, be_pid int, extra text), or an empty set if none.

EXAMPLES

           Note
           The following description applies only to Postgres-XC

       dblink module has not been tested with Postges-XC yet. Although there're no reason that
       dblink does not run in Postgres-XC, the development team leaves the test and the use of
       this module entirely to users.

       This section is identical to the corresponding PostgreSQL reference manual.

           Note
           The following description applies only to PostgreSQL

           SELECT dblink_exec('LISTEN virtual');
            dblink_exec
           -------------
            LISTEN
           (1 row)

           SELECT * FROM dblink_get_notify();
            notify_name | be_pid | extra
           -------------+--------+-------
           (0 rows)

           NOTIFY virtual;
           NOTIFY

           SELECT * FROM dblink_get_notify();
            notify_name | be_pid | extra
           -------------+--------+-------
            virtual     |   1229 |
           (1 row)