[Pgpool-general] Error when installing pgpool-regclass: undefined symbol: LookupNamespaceNoError

[Tatsuo Ishii]

> The version 3.0.2 can never be used because this version has problems, use 3.0.3 or 3.0.1 version. 

Correct.

However, the particular problem has not been detected and still
remains in 3.0.3. I will look into this.

In the mean time, you could omit the installation of
pgpool-regclass. Pgpool is smart enough to check if it has been
installed or not. The down side of not installing pgpool-regclass is,
if you have a plan to use schema qualified table names (for example
public.your_table). If you do not install the function, pgpool
neglects the schema name ("public" in this case) and might be confused
if you have same table name in other schema.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> ----- "Peter Loron" <ploron at intrepidls.com> escribió: 
>> Hello. I'm working on installing pgpool-II 3.0.2 on an Ubuntu 10.04 
>> server 64-bit machine. We're running Postgres 8.4. The compile and 
>> install of pgpool itself went fine, as did the make/install of 
>> pgpool_regclass. However, when I run the SQL command to activate the new 
>> module, I get the error shown below. 
>> 
>> Can anybody on the list shed some light on what is wrong? 
>> 
>> Thanks! 
>> 
>> 
>> ploron at coho:~/pgpool-II-3.0.2/sql/pgpool-regclass$ psql 
>> --username=postgres -f pgpool-regclass.sql template1 
>> psql:pgpool-regclass.sql:4: ERROR: could not load library 
>> "/usr/lib/postgresql/8.4/lib/pgpool-regclass.so": 
>> /usr/lib/postgresql/8.4/lib/pgpool-regclass.so: undefined symbol: 
>> LookupNamespaceNoError 
>> _______________________________________________ 
>> Pgpool-general mailing list 
>> Pgpool-general at pgfoundry.org 
>> http://pgfoundry.org/mailman/listinfo/pgpool-general 
>>