Re: [GENERAL] Error with plpython

2012-07-11 Thread Craig Ringer
On 07/11/2012 09:32 PM, Efraín Déctor wrote: Hello. This is what returns the 2 servers: Production Server: ['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg', '/usr/local/lib/python27.zip', '/usr/local/lib/python2.7', '/usr/local/lib/python2.7/plat-freebsd8', '/usr/local/lib

Re: [GENERAL] Error with plpython

2012-07-11 Thread Adrian Klaver
On 07/11/2012 04:17 PM, Efraín Déctor wrote: Hello. It is possible to upgrade without any downtime?. It it is problem you may want to confirm the Postgres version is a problem by setting up an 9.1.2 instance on your development machine and seeing if the error shows up. Otherwise that can b

Re: [GENERAL] Error with plpython

2012-07-11 Thread Efraín Déctor
Hello. It is possible to upgrade without any downtime?. Thank you. -Mensaje original- From: Adrian Klaver Sent: Wednesday, July 11, 2012 3:01 PM To: Efraín Déctor Cc: Craig Ringer ; pgsql-general@postgresql.org Subject: Re: [GENERAL] Error with plpython On 07/11/2012 06:32 AM

Re: [GENERAL] Error with plpython

2012-07-11 Thread Adrian Klaver
On 07/11/2012 06:32 AM, Efraín Déctor wrote: Hello. This is what returns the 2 servers: Production Server: ['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg', '/usr/local/lib/python27.zip', '/usr/local/lib/python2.7', '/usr/local/lib/python2.7/plat-freebsd8', '/usr/local/lib/p

Re: [GENERAL] Error with plpython

2012-07-11 Thread Efraín Déctor
is there a difference?: import sys plpy.notice(sys.path) Thanks -- Adrian Klaver adrian.kla...@gmail.com -Mensaje original- From: Craig Ringer Sent: Tuesday, July 10, 2012 10:43 PM To: Efraín Déctor Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Error with plpython

Re: [GENERAL] Error with plpython

2012-07-10 Thread Craig Ringer
On 07/11/2012 06:16 AM, Efraín Déctor wrote: 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

Re: [GENERAL] Error with plpython

2012-07-10 Thread Adrian Klaver
On 07/10/2012 05:34 PM, Efraín Déctor wrote: We tested, the code directly into Python: from googlemaps import GoogleMaps gmaps= GoogleMaps() address = gmaps.latlng_to_address(18.835124317498853,-97.11448417315677) repr(address) And on both servers work without a problem. My guess is that somet

Re: [GENERAL] Error with plpython

2012-07-10 Thread Efraín Déctor
is not working with plpython. But I don't know how to fix this. Thanks -Mensaje original- From: Adrian Klaver Sent: Tuesday, July 10, 2012 7:24 PM To: Efraín Déctor Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Error with plpython On 07/10/2012 02:59 PM, Efraín Déctor

Re: [GENERAL] Error with plpython

2012-07-10 Thread Adrian Klaver
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 FUNCT

[GENERAL] Error with plpython

2012-07-10 Thread Efraín Déctor
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, l

[GENERAL] Error with plpython

2012-07-10 Thread Efraín Déctor
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, l