[pgpool-general: 7663] Re: How to cache a SQL that is using customized function?

[Tatsuo Ishii]

> In the SQL, I guess that's because the function `getEntityRelationshipChildren` make pgpool ignore the result of this SQL? This is a function I created by myself, it would select some other table and return the result, basically, I hope it get cached.
> According to the document, there is a setting called `cache_safe_memqcache_table_list.` but the document says it just support view and table, so, how could I make this SQL cached?

You need to register getEntityRelationshipChildren() as an "immutable"
function as documented in the doc.
https://www.pgpool.net/docs/latest/en/html/runtime-in-memory-query-cache.html
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp