On 08/22/2015 12:23 AM, Igor Sosa Mayor wrote:
Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
Aargh, I was not paying attention.
Is the function you show here:
http://pastie.org/10366558
the actual function you are using in the trigger?
If so, there is no mechanism for getting the location coordinates into
the table, if that is what you want.
If that is not what you want, then what is the function supposed to do?
If it is not the trigger function, what is the actual function?
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.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
