| Lists: | pgsql-sql |
|---|
| From: | "Fang Genjie" <fanggj(at)email(dot)newpalm(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | the problem of createlang! |
| Date: | 2004-10-12 08:01:05 |
| Message-ID: | BA827320B7E9DA4D924DAE6489B523A6011CC13E@npbjemail.pdc.newpalm.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)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(at)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(at)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(at)wap1-np postgresql-7.4.5]$
What's the matter ?
Please help me!!!
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Fang Genjie" <fanggj(at)email(dot)newpalm(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: the problem of createlang! |
| Date: | 2004-10-19 21:31:55 |
| Message-ID: | 19940.1098221515@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-sql |
"Fang Genjie" <fanggj(at)email(dot)newpalm(dot)com> writes:
> [postgres(at)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
| From: | Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)cn> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: the problem of createlang! |
| Date: | 2004-10-20 14:57:34 |
| Message-ID: | 41767CDE.5040301@qmail.zhengmai.net.cn |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)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(at)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(at)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(at)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