[pgpool-general: 75] Re: Pgpool + streaming replication

[Tatsuo Ishii]

> W dniu 2011-12-08 20:06, Lazaro Rubén García Martinez pisze:
>>
>> You can rename the functions that use temporary tables adding a
>> prefix, for instance:
>>
>> fun_tmp.................
>>
>> and then you need modify the parameter black_function_list of
>> pgpool.conf like this:
>>
>> black_function_list = 'currval,lastval,nextval,setval,fun_tmp.*'
>>
>> As the result, all these functions will be execute only in the primary
>> server , but remember, you need to connect with the database through
>> pgpool-II.
>>
>> Regards.
>>
>>
> In my case the query it will be sent only to primary server so I can't
> use a secondary server.
> Yes, I understand, but our idea it was send a queries to both servers.

Being unable to use temporary table is a PostgreSQL limitation, not
pgpool's. Hope this will be resolved in the future.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp