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 [EMAIL PROTECTED] *** http://www.dontUthink.com/ http://groups.yahoo.com/group/newbieDoc -- next week's newbie needs your brain: document your experience today!