Hi there, I'd like to make a real-time enabled database and I need to process data asynchronously. Usually, there are many quick inserts sometimes causing vast updates. I can't use triggers and rules because the transactions are really long when there is the update (upgrade) needed. Is there a way how to listen and trigger the notify messages in the database (+-)immediately and/or to execute additional (trigger) queries in other transactions? In Oracle there is ON COMMIT trigger and an anonymous transaction that allows commit inside triggers. However this is not possible in Postgres. Moreover I can't know the check interval of the listening procedures in an external application (can be anything from millis to days). I was so desperate that I was thinking about own logging function. Many thanks, Petr -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
