Re: Problem with pl/python procedure connecting to the internet - Mailing list pgsql-general

From Igor Sosa Mayor
Subject Re: Problem with pl/python procedure connecting to the internet
Date
Msg-id 87d1yfeqgl.fsf@gmail.com
Whole thread Raw
In response to Problem with pl/python procedure connecting to the internet  (Igor Sosa Mayor <joseleopoldo1792@gmail.com>)
Responses Re: Problem with pl/python procedure connecting to the internet
Re: Problem with pl/python procedure connecting to the internet
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:

> Does the code work reliably outside Postgres?
> It seems you are reliant on the availability of the OpenStreetMap
> service and its ability to provide a timely response.
>
> So what exactly is the trigger event, INSERT, UPDATE, both?
>
> Is it absolutely necessary that this happen in a trigger?

yes, it works reliable. I can also add a timeout option, but it does not
make any difference.

As for the trigger: well, I don't know. I wanted to be triggered every
time I add a city in the table 'ciudad'.postgres deals

Somehow I have the impression postgres is trying to make a connection
without having to rights to get the answer (I'm on linux). I dont
understand exactly which process (and with which rights) is executing
the plpython procedure...

Thanks in any case for your answer.


--
:: Igor Sosa Mayor     :: joseleopoldo1792@gmail.com ::
:: GnuPG: 0x1C1E2890   :: http://www.gnupg.org/      ::
:: jabberid: rogorido  ::                            ::

pgsql-general by date:

Previous
From: Florin Andrei
Date:
Subject: master/master replication with load balancer in front
Next
From: John R Pierce
Date:
Subject: Re: Problem with pl/python procedure connecting to the internet