pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedthe problem of createlang!
3+ messages / 3 participants
[nested] [flat]
* the problem of createlang!
@ 2004-10-12 08:01 Fang Genjie <fanggj@email.newpalm.com>
2004-10-19 21:31 ` Re: the problem of createlang! Tom Lane <tgl@sss.pgh.pa.us>
2004-10-20 14:57 ` Re: the problem of createlang! Weiping <laser@qmail.zhengmai.net.cn>
0 siblings, 2 replies; 3+ messages in thread
From: Fang Genjie @ 2004-10-12 08:01 UTC (permalink / raw)
To: pgsql-sql
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]$
What's the matter ?
Please help me!!!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: the problem of createlang!
2004-10-12 08:01 the problem of createlang! Fang Genjie <fanggj@email.newpalm.com>
@ 2004-10-19 21:31 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-10-19 21:31 UTC (permalink / raw)
To: Fang Genjie <fanggj@email.newpalm.com>; +Cc: pgsql-sql
"Fang Genjie" <fanggj@email.newpalm.com> writes:
> [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
Looks like you are trying to load a 7.4 plpgsql.so into a pre-7.4
backend. You sure you updated your server?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: the problem of createlang!
2004-10-12 08:01 the problem of createlang! Fang Genjie <fanggj@email.newpalm.com>
@ 2004-10-20 14:57 ` Weiping <laser@qmail.zhengmai.net.cn>
1 sibling, 0 replies; 3+ messages in thread
From: Weiping @ 2004-10-20 14:57 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-10-20 14:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-12 08:01 the problem of createlang! Fang Genjie <fanggj@email.newpalm.com>
2004-10-19 21:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-20 14:57 ` Weiping <laser@qmail.zhengmai.net.cn>
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