listen.l 1.35 KB
Newer Older
1 2
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
3
.\" $Header: /cvsroot/pgsql/src/man/Attic/listen.l,v 1.8 1998/08/30 21:03:20 scrappy Exp $
4
.TH "LISTEN" SQL 03/12/94 PostgreSQL PostgreSQL
5
.SH NAME
Bruce Momjian's avatar
Bruce Momjian committed
6
listen - listen for notification on a relation
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
.SH SYNOPSIS
.nf
\fBlisten\fR class_name
.fi
.SH DESCRIPTION
.BR listen
is used to register the current backend as a listener on the relation
.IR class_name .
When the command 
.BI notify " class_name"
is called either from within a rule or at the query level, the
frontend applications corresponding to the listening backends 
are notified.  When the backend process exits, this registration
is cleared.
.PP
This event notification is performed through the Libpq protocol
and frontend application interface.  The application program 
24
must call the routine
25 26 27 28 29
.IR PQnotifies
in order to find out the name of the class to which a given 
notification corresponds.  If this code is not included in 
the application, the event notification will be queued and 
never be processed.
30 31 32 33 34 35
.PP
Note that
.IR class_name
needs not to be a valid class name but can be any ascii string up to 32
characters long. It must however be eclosed in double-quotes if it is
not valid as class name.
36
.SH "SEE ALSO"
37
create_rule(l),
38 39
notify(l),
select(l),
40
unlisten(l),
41 42 43
libpq.
.SH BUGS
The
Bruce Momjian's avatar
Bruce Momjian committed
44
.IR psql(1)
45
command does not poll for asynchronous events.