SEO

#1 (**permalink**) 04-12-2008, 08:38 AM

Folks,

While trying to test the arrays of complex types, I used a
stripped-down configure. Too stripped down, it turns out.

CFLAGS="-O0" ./configure --prefix=/var/lib/pgsql/tip --with-pgport=2225 --enable-cassert --enable-debug --enable-depend --enable-integer-datetimes

I set $PGDATA to my test directory, then did

initdb -D $PGDATA -E utf8
createdb array_test
createlang plperlu array_test

then spent some time trying to figure out why I got the following
error when I tried to create a PL/PerlU function:

psql:schema.sql:4259: ERROR: cache lookup failed for function 1000

It turns out that PL/PerlU wasn't available, even though createlang
had succeeded. I think this is a bug in CREATE LANGUAGE, as CREATE
LANGUAGE should have failed when it found no PL/Perl compiled in.

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

#2 (**permalink**) 04-12-2008, 08:38 AM

David Fetter <david@fetter.org> writes:
> It turns out that PL/PerlU wasn't available, even though createlang
> had succeeded. I think this is a bug in CREATE LANGUAGE, as CREATE
> LANGUAGE should have failed when it found no PL/Perl compiled in.

Works for me:

$ createlang plperlu array_test
createlang: language installation failed: ERROR: could not access file "$libdir/plperl": No such file or directory

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Problem with CREATE LANGUAGE in CVS TIP