Re: Python + listen/notify

From: Filipe brandão <fg(dot)brandao(at)gmail(dot)com>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Python + listen/notify
Date: 2012-07-12 10:28:19
Message-ID: CAAOJB6e8QQKgbMKM0xqLgaJgNR_kBxZrXEt0Rm8f=8DEsu_1bQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hei Josh, problem solved!

Thanks for your help!

On Wed, Jul 11, 2012 at 4:27 PM, Josh Kupershmidt <schmiddy(at)gmail(dot)com>wrote:

> [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.
>

--
Filipe Brandão

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johann Spies 2012-07-12 10:42:00 Full text search advice requested
Previous Message Craig Ringer 2012-07-12 07:39:11 Re: PostgreSQL limitations question