X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CEA629DC81E for ; Thu, 2 Feb 2006 22:10:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31263-05 for ; Thu, 2 Feb 2006 22:10:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.unika.ac.id (unknown [203.130.205.66]) by postgresql.org (Postfix) with SMTP id B9FE89DCBBB for ; Thu, 2 Feb 2006 22:10:14 -0400 (AST) Received: (qmail 16480 invoked by uid 507); 3 Feb 2006 09:18:32 +0700 Message-ID: <20060203021832.16478.qmail@mail.unika.ac.id> References: <20060202035513.10304.qmail@mail.unika.ac.id> <45dd8dbe0602020507u5bd55f0ft2aadf415dadb46f6@mail.gmail.com> In-Reply-To: <45dd8dbe0602020507u5bd55f0ft2aadf415dadb46f6@mail.gmail.com> From: slackman@unika.ac.id To: pgsql-admin@postgresql.org Cc: dbrignar@gmail.com Subject: Re: is there any missing ?? Date: Fri, 03 Feb 2006 09:18:32 +0700 Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Sender: slackman@unika.ac.id X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.653 required=5 tests=[AWL=0.103, NO_REAL_NAME=0.55] X-Spam-Score: 0.653 X-Spam-Level: X-Archive-Number: 200602/29 X-Sequence-Number: 20450 %bin/createlang plpythonu template1; createlang: language installation failed: ERROR: could not load library "/usr/local/pgsql/lib/plpython.so": dlopen (/usr/local/pgsql/lib/plpython.so) failed: /usr/local/pgsql/lib/plpython.so: Undefined symbol "pthread_create" % in my w2k box i use this function, CREATE FUNCTION plpython_call_handler() RETURNS language_handler AS '$libdir/plpython' LANGUAGE C; CREATE LANGUAGE python HANDLER plpython_call_handler; is it okay?? Dario Brignardello writes: > Well, according to the docs at > http://www.postgresql.org/docs/8.1/interactive/plpython.html > the correct name would be "plpythonu". > As a matter of facts, you can do a > 'select tmplname from pg_pltemplate;' > to check wich languages are available. > > Hope it helps. > Best regards > Dario > > > > > On 2/2/06, slackman@unika.ac.id wrote: >> >> # ./configure --prefix=/usr/local/pgsql --with-python >> # make >> # make install >> # adduser postgres >> # mkdir /usr/local/pgsql/data >> # chown postgres /usr/local/pgsql/data >> # su postgres >> % /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data >> % /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l >> /usr/local/pgsql/pg_start.log start >> %/usr/local/pgsql/bin/createlang plpython template1 >> createlang: language installation failed: ERROR: unsupported language >> "plpython" >> HINT: The supported languages are listed in the pg_pltemplate system >> catalog. >> % >> i there any missing ??? >> i have configured python lib >> my box is using freebsd 5.0, python 2.4.2, postgresql-8.1.2 >> thank you all for your kinness >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Have you searched our list archives? >> >> http://archives.postgresql.org >> > > > > -- > Atte: Dario Brignardello