Обсуждение: the problem of createlang!

<div class="Section1" style="layout-grid:15.6pt"><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">I have installed postgresql (version 7.4.5) on the Redhat linux platform.</span></font><p
class="MsoNormal"><fontface="Arial" size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial">Now I want to create a database with name BBMF and create pl/pgsql procedure language to the
BBMF</span></font><pclass="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial">The problem is listed follow:</span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">[postgres@wap1-np postgresql-7.4.5]$ psql -l</span></font><p class="MsoNormal"><font
face="Arial"size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial">        List of databases</span></font><p class="MsoNormal"><font face="Arial" size="1"><span
lang="EN-US"style="font-size: 
9.0pt;font-family:Arial"> Database  |  Owner   | Encoding  </span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial">-----------+----------+-----------</span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial"> BBMF      | develop  | SQL_ASCII</span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial"> template0 | postgres | SQL_ASCII</span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial"> template1 | postgres | SQL_ASCII</span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial">(3 rows)</span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">[postgres@wap1-np postgresql-7.4.5]$ createlang plpgsql BBMF</span></font><p
class="MsoNormal"><fontface="Arial" size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial">ERROR:  Load of file /usr/local/pgsql/lib/plpgsql.so failed: /usr/local/pgsql/lib/plpgsql.so:
undefinedsymbol: error_context_stack</span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">createlang: language installation failed</span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial">[postgres@wap1-np postgresql-7.4.5]$ file /usr/local/pgsql/lib/plpgsql.so </span></font><p
class="MsoNormal"><fontface="Arial" size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial">/usr/local/pgsql/lib/plpgsql.so: ELF 32-bit LSB shared object, Intel 80386, version 1, not
stripped</span></font><pclass="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial">[postgres@wap1-np postgresql-7.4.5]$</span></font><p class="MsoNormal"><font face="Arial"
size="1"><spanlang="EN-US" style="font-size: 
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">What’s the matter ? </span></font><p class="MsoNormal"><font face="Arial" size="1"><span
lang="EN-US"style="font-size: 
9.0pt;font-family:Arial">Please help me!!!</span></font></div>

"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

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