[Pgpool-general] pgpool-II: Query cache expire time

[Arthur Turrini]

Hi,

I have the following scenario, "Client A" connecting through pgpool-II and "Client B" connecting directly:

Client A: SELECT * FROM sasl.people;			(it returns 30 records and get cached by pgpool)
Client B: SELECT * FROM sasl.people;			(it returns the same 30 records)
Client B: INSERT INTO sasl.people VALUES (....);	(inserts one record)
Client B: SELECT * FROM sasl.people;			(it now return 31 records)
Client A: SELECT * FROM sasl.people;			(it stills returns 30 records :( )

How I can avoid that ? There's a way to set an expire time to pgpool's query cache?

Regards,

---
Arthur Turrini.

PS: pgpool is a great product! keep the good job!