SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:46 AM
| ||||
| ||||
 is there any missing ?? # ./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      |
|
04-10-2008, 05:46 AM
| |||
| |||
| Re: is there any missing ?? Well, according to the docs at http://www.postgresql.org/docs/8.1/i.../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 <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 |
|
04-10-2008, 05:47 AM
| |||
| |||
| Re: is there any missing ?? %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/i.../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 <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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-10-2008, 05:47 AM
| ||||
| ||||
| Re: is there any missing ?? On Fri, Feb 03, 2006 at 09:18:32AM +0700, slackman@unika.ac.id wrote: > %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" There have been previous reports of PL/Python problems on FreeBSD. I'm not sure what the current status is; search the list archives for past discussion. I think one solution is to build a non-threaded Python (WITHOUT_THREADS=yes if you're installing from the ports collection), but that obviously has implications for other Python applications. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
Linear Mode
