[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

postgresql 7.0.3 -- but NO plperl ?

i haven't figured out how to turn on 'plperl' yet on potato:

% grep tfheen /etc/apt/sources.list
deb http://www.samfundet.no/~tfheen/debian potato main

% dpkg -l '*p*g*sql*' | egrep 'pg|postgre' | grep -v php
un  libpgsql       <none>         (no description available)
ii  libpgsql2      7.0.3-0potato1 Shared library libpq.so.2 for PostgreSQL
ii  postgresql     7.0.3-0potato1 Object-relational SQL database, descended fr
ii  postgresql-cli 7.0.3-0potato1 Front-end programs for PostgreSQL
ii  postgresql-con 7.0.3-0potato1 Additional facilities for PostgreSQL
ii  postgresql-dev 7.0.3-0potato1 Header files for libpq (postgresql library)
ii  postgresql-doc 7.0.3-0potato1 Documentation for the PostgreSQL database.
ii  postgresql-pl  7.0.3-0potato1 A procedural language for PostgreSQL
in  postgresql-sli <none>         (no description available)

here we go:

% psql tinker
tinker=# create function one() returns int4
tinker-# as 'return 1;'
tinker-# language 'plperl'
ERROR: unrecognized language in a CREATE FUNCTION:
'plperl'. Recognized languages are sql, C, internal and
the created procedural languages.

what incantation have i missed?

See, if you were allowed to keep the money, you wouldn't
create jobs with it. You'd throw it in the bushes or
something.  But the government will spend it, thereby
creating jobs.      -- Dave Barry

will@serensoft.com    ***    http://www.dontUthink.com/

http://groups.yahoo.com/group/newbieDoc -- next week's
newbie needs your brain: document your experience today!

Reply to: