Re: BUG #5641: Can not create any python language

Hi Ron,

I am able to reproduce the issue on my side..
Thanks for the report.

I found that - plpython.dll is not exporting any plpython_call_handler
function, but plpython3_call_handler.

For the work around, you can follow this link:
1) Go to PostgreSQL lib directory
i.e. C:\Program Files\PostgreSQL\9.0\lib
2) Copy plpython.dll as plpython3.dll in the same directory.

Now, try to create the plpython3u language in PostgreSQL.
i.e. CREATE LANGUAGE plpython3u;

This is just a temporary solution and I wish - this solves the problem for
you.
We will come up with a better solution soon.

--
*Thanks & Regards,*
*
*
*Ashesh Vashi*
*EnterpriseDB INDIA:* Enterprise Postgres Company<http://www.enterprisedb.com>

On Thu, Sep 9, 2010 at 3:25 PM, Ashesh Vashi
<ashesh(dot)vashi(at)enterprisedb(dot)com>wrote:

> Hi,
>
> Can you share the postgresql log file, when you tried to create the python
> language on PG 9.0?
>
> --
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA
>
>
> On Fri, Sep 3, 2010 at 3:03 AM, Ron Park <rparkjr(at)gmail(dot)com> wrote:
>
>>
>> The following bug has been logged online:
>>
>> Bug reference: 5641
>> Logged by: Ron Park
>> Email address: rparkjr(at)gmail(dot)com
>> PostgreSQL version: 9.0
>> Operating system: Windows 7 professional 64 bit
>> Description: Can not create any python language
>> Details:
>>
>> when trying to create plpythonu
>>
>> ERROR: could not find function "plpython_call_handler" in file
>> "C:/Program
>> Files/PostgreSQL/9.0/lib/plpython.dll"
>>
>>
>> when trying to create plpython2u or plpython3u I get
>> ERROR: could not access file "$libdir/plpython2": No such file or
>> directory
>>
>> ERROR: could not access file "$libdir/plpython3": No such file or
>> directory
>>
>>
>> I have python2.6, python3.1, python3.2 all installed (64 bit). All are in
>> the path variable.
>>
>> used 9.0 MSI from enterprise to install postgresql 9.0
>>
>> I have been running and using the 8.xx ones on windows 32 bit and ubuntu
>> for
>> 6 years and have been able to get python to behave well on both systems.
>> But I am at a loss here.. Looks like there is a bug in the plpython.dll
>> missing the call handler??? Not sure
>>
>> --
>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
>>
>
>