The following bug has been logged online:

Bug reference: 1491
Logged by: Alexis Wilke
Email address: alexis (AT) m2osw (DOT) com
PostgreSQL version: 8.0.1
Operating system: Linux
Description: Getting an "undefined symbol" when loading contrib mod.
Details:

I'm trying to use ltree to sort one of my table using a tree like column
("1", "1.1", "1.2", "2", "2.1", etc.)

Everything compiles, after my fix to the .sql.in -> .sql convertion
($(libdir) instead of $$libdir in pgxs.mk) and everything also seems to be
installed properly.

However, in version 7.4.6 and version 8.0.1, when I try to load the module,
it says it can't find the symbol errstart (one of the elog functions better
known as ereport).

There are a few versions if that helps at all...

gcc (GCC) 3.4.3

GNU ld version 2.13.90.0.18 20030206

ldd (GNU libc) 2.3.2

There is the complete message I'm getting from postgres

crm=> SET search_path = public;
SET
crm=> CREATE FUNCTION ltree_in(cstring)
crm-> RETURNS ltree
crm-> AS '/usr/local/pgsql/lib/ltree'
crm-> LANGUAGE 'C' WITH (isstrict);
NOTICE: ProcedureCreate: type ltree is not yet defined
ERROR: Load of file /usr/local/pgsql/lib/ltree.so failed:
/usr/local/pgsql/lib/ltree.so: undefined symbol: errstart

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

"Alexis Wilke" <alexis (AT) m2osw (DOT) com> writes:
You need to be a lot more specific than that, because this stuff works
fine on all the variants of Linux we know about.

Are you sure you're loading into a 7.4-or-later backend? (Check "select
version();" to be certain.) The only other possibility I can think of
is that the backend has been stripped of symbols --- in which case it's
not errstart that's at fault particularly, that just happens to be the
first missing symbol reported.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match