>> If any of the tables were modified, cache entries using the table must be
> removed.
>> (these are already implemented in Pgpool-II's in memory query cache)
>
> How do you identify updates made from a pl/pgsql procedure?
Pgpool-II does not invalidate query cache in that case.
I think in-core query cache could deal with the case (probably as
Michael suggested).
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp