From: Weiping <laser@qmail.zhengmai.net.cn>
To: pgsql-sql@postgresql.org
Subject: Re: the problem of createlang!
Date: Wed, 20 Oct 2004 22:57:34 +0800
Message-ID: <41767CDE.5040301@qmail.zhengmai.net.cn> (raw)
In-Reply-To: <BA827320B7E9DA4D924DAE6489B523A6011CC13E@npbjemail.pdc.newpalm.com>
References: <BA827320B7E9DA4D924DAE6489B523A6011CC13E@npbjemail.pdc.newpalm.com>
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:
>
>
>
> [postgres@wap1-np 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)
>
>
>
> [postgres@wap1-np 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
>
> [postgres@wap1-np 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
>
> [postgres@wap1-np 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: laser@qmail.zhengmai.net.cn
Subject: Re: the problem of createlang!
In-Reply-To: <41767CDE.5040301@qmail.zhengmai.net.cn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox