Problem with CREATE LANGUAGE in CVS TIP - Mailing list pgsql-hackers

From David Fetter
Subject Problem with CREATE LANGUAGE in CVS TIP
Date
Msg-id 20070510010651.GB747@fetter.org
Whole thread Raw
Responses Re: Problem with CREATE LANGUAGE in CVS TIP
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Re: [COMMITTERS] psqlodbc - psqlodbc: Put Autotools-generated files into subdirectory
Next
From: "CK Tan"
Date:
Subject: Re: Seq scans roadmap