Yoshiyuki Asaba [Fri, May 16, 2008 at 12:02:07PM +0900]: > Hi, > > From: Nico -telmich- Schottelius <[EMAIL PROTECTED]> > Subject: [Pgpool-general] Logging / why was failover_handler called? > Date: Thu, 15 May 2008 17:32:41 +0200 > > > 2008-05-15 14:17:14 CEST LOG: statement: SET DateStyle=ISO;SELECT oid, > > pg_encoding_to_char(encoding) AS encoding, datlastsysoid FROM pg_database > > WHERE oid = 33100 > > It is a restriction. Pgpool cannot sync OID among replication servers > because of statement based replication.
So the failover was called because we used the where clause "oid = 33100"?
If that's the case, can't we just decline that statement ("NOT SUPPORTED")?
Nico
--
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/
PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C
signature.asc
Description: Digital signature
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
