Re: Python + listen/notify - Mailing list pgsql-general

From Josh Kupershmidt
Subject Re: Python + listen/notify
Date
Msg-id CAK3UJRGGAw8P2fS=GUu_5MuD6g6LXGw25-v5X+UH68gwHhr4OQ@mail.gmail.com
Whole thread Raw
In response to Python + listen/notify  (Filipe Brandão <fg.brandao@gmail.com>)
List pgsql-general
On Tue, Jul 10, 2012 at 3:56 PM, Filipe Brandão <fg.brandao@gmail.com> 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

pgsql-general by date:

Previous
From: Filipe Brandão
Date:
Subject: Python + listen/notify
Next
From: Craig Ringer
Date:
Subject: Re: Error with plpython