Josh Berkus wrote:
> Tatsuo,
>>Yes. However it would be pretty easy to modify pgpool so that it could
>>cope with Slony-I. I.e.
>>1) pgpool does the load balance and sends query to Slony-I's slave and
>>   master if the query is SELECT.
>>2) pgpool sends query only to the master if the query is other than
>>   SELECT.

Don't you think that this is unsafe ?

SELECT foo(id), id
FROM bar;

where foo have side effect.

Is pgpool able to detect it and perform this select on the master ?

Gaetano Mendola

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to