Fang Genjie wrote:
I have installed postgresql (version 7.4.5) on the Redhat linux platform.
Now I want to create a database with name BBMF and create pl/pgsql procedure language to the BBMF
The problem is listed follow:
[EMAIL PROTECTED] postgresql-7.4.5]$ psql -l
List of databases
Database | Owner | Encoding
-----------+----------+-----------
BBMF | develop | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(3 rows)
[EMAIL PROTECTED] postgresql-7.4.5]$ createlang plpgsql BBMF
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: /usr/local/pgsql/lib/plpgsql.so: undefined symbol: error_context_stack
createlang: language installation failed
[EMAIL PROTECTED] postgresql-7.4.5]$ file /usr/local/pgsql/lib/plpgsql.so
/usr/local/pgsql/lib/plpgsql.so: ELF 32-bit LSB shared object, Intel 80386, version 1, not stripped
[EMAIL PROTECTED] postgresql-7.4.5]$
Most probably is you got two version of postgresql in you system, one from RH, one install by yourself. check the path of your installation and the system one (usually /usr/bin, /usr/lib etc for RH).
regards
Laser
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
