[Pgpool-general] Generate UUID with pgpool-II

[Tatsuo Ishii]

> Thank you very much for your answer, but now I write you because I have a conceptual doubt about pgpool-II. Is pgpool-II only a statement-based replication middleware? 

Yes, pgpool-II is definitely statement based. Though I prefer to use
the term "query based replication". Because "statement" is oversimply
the fact which pgpool-II is doing. Think about extended protocol. A
query can be consisted with multiple "statement" (prepare, bind,
execute etc.)

> I have this doubt because pgpool-II selects a master node, when failover is performed and my confusion is between statement-based replication middleware and multi-master tecniques. 

I don't understand your question here. "Multi-master" replication and
query based replication are orthogonal concepts.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Thank you very much for your time. 
> Regards. 
> 
> 
> ----- "Tatsuo Ishii" <ishii at sraoss.co.jp> escribió: 
>> > Hello everyone. I have a database than contain many field with uuid type. Is there any way to generate an uuid by Pgpool-II in replication mode for ensure that this value will be identical in all the nodes?? 
>> 
>> Currently I don't think of any way to replicate uuid 
>> data. Theoretically we could ask master node to generate uuid data 
>> then INSERT the value to other nodes. This is essentially same as the 
>> way timestamp support does. Of course this needs to patch pgpool. 
>> -- 
>> Tatsuo Ishii 
>> SRA OSS, Inc. Japan 
>> English: http://www.sraoss.co.jp/index_en.php 
>> Japanese: http://www.sraoss.co.jp 
>>