Re: Problem with pl/python procedure connecting to the internet

From: Igor Sosa Mayor <joseleopoldo1792(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with pl/python procedure connecting to the internet
Date: 2015-08-22 17:16:17
Message-ID: 874mjrdz1a.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:

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

this is the function and there is a trigger which gets the coordinates
into the table. It works perfectly when postgres is able to make a
connection and get the data. But this is exactly what works only
rarely... And I dont know the reason...

PS: this is the trigger, but as I said, it works if there is a
connection...
http://pastie.org/10368578

--
:: Igor Sosa Mayor :: joseleopoldo1792(at)gmail(dot)com ::
:: GnuPG: 0x1C1E2890 :: http://www.gnupg.org/ ::
:: jabberid: rogorido :: ::

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2015-08-22 17:57:07 Re: How to use record variable with non-null domain in plpgsql
Previous Message Tom Lane 2015-08-22 17:16:02 Re: PostgreSQL Developer Best Practices