[Pgpool-general] pgpool-II 2.0.1: "pool_process_query: 1 th kind D does not match with master connection kind C" error

[Yoshiyuki Asaba]

Hi,

From: "Anthony MacKinnon" <anthony.mackinnon at waypointinfo.com>
Subject: Re: [Pgpool-general] pgpool-II 2.0.1: "pool_process_query: 1 th kind D does not match with master connection kind C" error
Date: Fri, 21 Dec 2007 14:07:00 -0500

> 2007-11-29 02:00:18 LOG:   pid 11118: statement: SET SESSION AUTHORIZATION
> some_account;select * from some_table where (some_column='value') AND
> (other_column='43')

pgpool cannot process a multi statement query properly in current
version. So you need to modify your program.

  PQexec("SET ...; SELECT ...");

  ->

  PQexec("SET ...");
  PQexec("SELECT ...");

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp