On Tue, Jul 26, 2005 at 06:25:23PM -0300, Adam O'Toole wrote: > I am searching for a way to have my postgresql 7.4.7 backend be triggered to > let the front end know there has been a change to the database. If more then > one person is connected to the database and person (x) makes a change, I want > other clients to then be aware of that, and refresh there screen so they are > not then looking at out of date data. > Any insight? Thank you so much, have a great day. GNUmed has a complete Python implementation of what you describe. We are using triggers and listen/notify as others suggested. Look at client/pycommon/gmBackendListener.py for the middleware, then server/sql/gmNotifications.sql for the schema support, and server/bootstrap/gmNotificationSchemaGenerator.py for a way to generate the needed triggers at the time of bootstrapping the database. http://salaam.homeunix.com/~ncq/gnumed/snapshot/gnumed-latest-snapshot.tgz Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
