Re: Error with plpython - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Error with plpython
Date
Msg-id 4FFCC7C5.60600@gmail.com
Whole thread Raw
In response to Error with plpython  (Efraín Déctor <efraindector@motumweb.com>)
Responses Re: Error with plpython
List pgsql-general
On 07/10/2012 02:59 PM, Efraín Déctor wrote:
> Hello.
> Strange thing happening:
> We rencently installed plpython in one of our test servers and installed
> an extension to use the google api
> (http://pypi.python.org/pypi/googlemaps) , everything went fine we
> tested this function:
> CREATE OR REPLACE FUNCTION google_reverse_geocode(lat numeric, lon numeric)
>    RETURNS text AS
> $BODY$
>      from googlemaps import GoogleMaps
>      gmaps= GoogleMaps()
>      address =  gmaps.latlng_to_address(lat,lon)
>      return (address)
> $BODY$
>    LANGUAGE plpythonu VOLATILE
>    COST 100;
> ALTER FUNCTION google_reverse_geocode(numeric, numeric)
>    OWNER TO pgsql;
> However, once we installed it on our production server that function
> doesnt work, it keeps sending this message:
> ERROR:  ImportError: cannot import name SSLError
> CONTEXT:  Traceback (most recent call last):
> The strange thing is that our server are the same in everything so we
> don’t know why is failing in our production eviroment.

At a guess something is not the same:)
1) Does SSLError exist on the production server
2) If it does exist, is it in the Python path?


> Thanks in advance.


--
Adrian Klaver
adrian.klaver@gmail.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Transaction question
Next
From: Efraín Déctor
Date:
Subject: Re: Error with plpython