On Tue, Jul 10, 2012 at 3:56 PM, Filipe Brandão <[email protected]> wrote: > Hi all. > I needed to have a trigger firing after a commit, but allready realized it's > not possible. > As i searched upon a solution i came across the LISTEN / NOTIFY. I haven't > yet realized exactly what i can do with it, but can i use it to run a simple > python script located out my DB? > Can't run it inside the DB since i need to do it after the completion of a > few triggers (after commit).
Certainly: your python program should stay connected to the database, waiting to receive the NOTIFYs, and then take appropriate action. See: http://packages.python.org/psycopg2/advanced.html#asynchronous-notifications Josh -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
