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.
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
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 18.104.22.168.18 20030206
ldd (GNU libc) 2.3.2
There is the complete message I'm getting from postgres
crm=> SET search_path = public;
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
pgsql-bugs by date
|Next:||From: Rong Wang||Date: 2005-02-21 04:38:28|
|Subject: BUG #1492: PostgreSQL ODBC error|
|Previous:||From: Alexis Wilke||Date: 2005-02-20 08:34:10|
|Subject: BUG #1490: contrib .sql.in sed command bogus|