[Pgpool-committers] pgpool - pgpool: Enhance that the query that begins with "SELECT

User Y-asaba y-asaba at pgfoundry.org
Fri Apr 20 06:14:21 UTC 2007


Log Message:
-----------
Enhance that the query that begins with "SELECT nextval()" or "SELECT
setval()" are always replicated under replication mode.

Then, SELECT statements are only executed by MASTER node if
load_balance_mode is false. If need to replicate select statement, add
a comment in the begining of the query.

Example:
  SELECT foo() -> /*REPLICATION*/ SELECT foo()

Modified Files:
--------------
    pgpool:
        pool_process_query.c (r1.42 -> r1.43)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool/pool_process_query.c.diff?r1=1.42&r2=1.43)


More information about the Pgpool-committers mailing list