On 29 Mar 2012, at 11:43, Albert wrote: > it a browser based application. so would you advice me about the best way to > poll the database for notifications ? > > I've been read about DB triggers but still can't tell if it will help me. The HTTP protocol doesn't have a push mechanism, so you can't notify your browser-based application from your server. You will have to poll. Googling for "ajax push" turned up this explanation: http://www.subbu.org/blog/2006/04/dissecting-ajax-server-push Alban Hertroys -- The scale of a problem often equals the size of an ego. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general