[Pgpool-general] Logging / why was failover_handler called?

[Nico -telmich- Schottelius]

Yoshiyuki Asaba [Fri, May 16, 2008 at 12:02:07PM +0900]:
> Hi,
> 
> From: Nico -telmich- Schottelius <nico-pgpool at schottelius.org>
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080516/f98a0105/attachment.bin