Skip site navigation (1) Skip section navigation (2)

Re: the problem of createlang!

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 (view raw or flat)
Thread:
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

In response to

pgsql-sql by date

Next:From: Markus BertheauDate: 2004-10-20 15:58:12
Subject: time of constraint checking
Previous:From: Rod TaylorDate: 2004-10-20 13:05:38
Subject: Re: Reuse previously calculated column in sql query?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group