From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
---|---|
To: | Filipe brandão <fg(dot)brandao(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Python + listen/notify |
Date: | 2012-07-11 15:27:58 |
Message-ID: | CAK3UJRFUi=dnC_MSD4OGb2VMwvjPnWrzcqX24ujLViPaOAeDMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
[Please keep the list CC'd]
On Wed, Jul 11, 2012 at 3:58 AM, Filipe brandão <fg(dot)brandao(at)gmail(dot)com> wrote:
> Now, i only need to link these processes (trigger completion and running the
> script).
> How can i do it with Listen / Notify? Issue a notify in the end of the
> trigger and a listen on the python script?
Yes, that should work fine. See the doc pages for LISTEN and NOTIFY:
http://www.postgresql.org/docs/current/static/sql-listen.html
http://www.postgresql.org/docs/current/static/sql-notify.html
Along with the link I sent earlier to the psycopg2 section, assuming
you are in fact using psycopg2 as your database connector. I suggest
trying out the psycopg2 example in their docs verbatim first, then
adapting the example to your own code.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-07-11 15:35:04 | Re: Key not present in table, but it is. |
Previous Message | Jeremaine Johnson | 2012-07-11 15:17:10 | Fulltext Search Function |