the problem of createlang! - Mailing list pgsql-sql
From | Fang Genjie |
---|---|
Subject | the problem of createlang! |
Date | |
Msg-id | BA827320B7E9DA4D924DAE6489B523A6011CC13E@npbjemail.pdc.newpalm.com Whole thread Raw |
Responses |
Re: the problem of createlang!
Re: the problem of createlang! |
List | pgsql-sql |
<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>