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 :: ::