Re: Synchronous LISTEN/NOTIFY?

Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> Uhoh, since I'm using perl does that mean I have to patch DBI and Pg::DBD?

Couldn't say.  I didn't have much trouble setting up a Tcl application
to work smoothly with NOTIFY events, but I've never tried such a thing
in Perl.  Any Perl gurus out there who can pontificate about how to
set up an event loop in Perl?

> Would it be viable idea to add a WAIT command/statement for higher level
> access (e.g. "SQL" level access to this feature)?

Strikes me as pretty useless.  If you were to PQexec("WAIT foo") then
your application would be totally locked up until and unless a foo
signal gets delivered.  You won't be satisfied with that for long.

            regards, tom lane