People asked me to put a simple extension for PostgreSQL Open Source.
The attached package contains a simple functions whichs tells a remote TCP socket that somebody is about to modify a certain table.
Why would anybody do that?
Currently PostgreSQL provides a nice LISTEN / NOTIFY mechanism. However, this mechanism is obsolete when the machine which should receive a message is not connected to PostgreSQL directly.
In this case it is possible to define a trigger on a table and let the database tell those machines via TCP that something interesting might have happened.
In our case this package has helped us to get rid of permanent, speed consuming polling.
Maybe some people might find it useful and want to see this feature in contrib.
Please let us know.
Regards,
Hans
-- Cybertec Geschwinde u Schoenig Schoengrabern 134, A-2020 Hollabrunn, Austria Tel: +43/2952/30706 or +43/664/233 90 75 www.cybertec.at, www.postgresql.at, kernel.cybertec.at
tecwing.tgz
Description: GNU Zip compressed data---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
