From: "Joel Burton" <jburton@scw.org>
Organization: Support Center of Washington
To: pgsql-interfaces@postgresql.org
Date: Wed, 19 Jul 2000 12:44:23 -0400
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: LISTEN/NOTIFY: can I use with Microsoft Access 97?
Message-ID: <3975A2A7.6044.9699327@localhost>

I've used LISTEN and NOTIFY from pgsql, however I can't find out 
how to get them to work w/Access.

I know how to run a query as a pass-through query. I also know 
how to log messages from the server to the messages tables (eg 
Admin - 00, Admin - 01, etc.), so I can see the RAISE NOTICE 
commands that I use for debugging. However, the NOTIFY 
messages never appear in these message logs.

I'd love to have a trappable Access error when it receive 
notification; I'd be very happy to have it log to a table or some 
other place I could see it.

Any ideas or help would be very appreciated.
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)