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 874mjrdz1a.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
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.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@gmail.com ::
:: GnuPG: 0x1C1E2890   :: http://www.gnupg.org/      ::
:: jabberid: rogorido  ::                            ::

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL Developer Best Practices
Next
From: "Andrus"
Date:
Subject: Re: How to use record variable with non-null domain in plpgsql