"Multiple statements are an issue with pgPool-II in its replication mode" again

From: TAKATSUKA Haruka <harukat(at)sraoss(dot)co(dot)jp>
To: pgadmin-support(at)postgresql(dot)org
Subject: "Multiple statements are an issue with pgPool-II in its replication mode" again
Date: 2010-11-22 06:38:19
Message-ID: 20101122153819.187231d4.harukat@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi, pgadmin-team.

This fix to execute "Set ..." and "SELECT ..." separately was
overwritten. Now pgAdmin-III 1.12.1 cannot connect pgpool-II
replication cluster. (*)

Is it has any reason ?
(e.g. There are many multiple-statements and they decide to give up ...)

2009-07-20 GL 1.12.0 Multiple statements are an issue with pgPool-II in
its replication mode.

* commitdiff: (fix multiple statements)
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=ef994af1e7a4bbd24f29fd99f452cbe315786286

* diff to current: (use multiple statements again)
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=blobdiff;f=pgadmin/db/pgConn.cpp;h=ea4aaa5b436f14494170c0994db23669ac953b00;hp=e4132817f6a896500689407829d75c2f92b95f57;hb=HEAD;hpb=ef994af1e7a4bbd24f29fd99f452cbe315786286

(*) pgpool-II execute multiple-SQLs at all backend nodes according to
its feature and to run 'SELECT ... WHERE oid = 12345' generate diffrent
answers. It causes an error.

______________________________________________________________________
TAKATSUKA Haruka harukat(at)sraoss(dot)co(dot)jp SRA OSS, Inc.
http://www.sraoss.co.jp/

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Julien Rouhaud 2010-11-22 12:06:17 PgAgent - return code on batch step on Windows
Previous Message TAKATSUKA Haruka 2010-11-22 02:11:38 "Multiple statements are an issue with pgPool-II in its replication mode" again