Implement automatic writing function detection by checking volatile property.
authorTatsuo Ishii <ishii@sraoss.co.jp>
Sun, 2 Aug 2020 07:00:41 +0000 (16:00 +0900)
committerTatsuo Ishii <ishii@sraoss.co.jp>
Sun, 2 Aug 2020 07:00:41 +0000 (16:00 +0900)
commitb7f902d9305e0fda8ed3a8c9f098bcffae45f6b8
tree40996d24df9d0dc583598b51fa3b5a94928a76f1
parentd7c7578148f0026bbe439f8920c62cb809206466
Implement automatic writing function detection by checking volatile property.

If a function included in SELECT/WITH has volatile property by
checking system catalog, regard it a writing function. This feature is
available only when the black_function_list and the
white_function_list are both empty. The default of the
black_function_list and the white_function_list are now empty string
so that this feature is enabled by default.

If the black_function_list or the white_function_list is not empty,
keep on existing behavior (only consult the black_function_list or the
white_function_list, not access system catalog).

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2020-July/003730.html
Reviewed-by: Hou, Zhijie
doc.ja/src/sgml/loadbalance.sgml
doc/src/sgml/loadbalance.sgml
src/sample/pgpool.conf.sample-logical
src/sample/pgpool.conf.sample-raw
src/sample/pgpool.conf.sample-replication
src/sample/pgpool.conf.sample-slony
src/sample/pgpool.conf.sample-snapshot
src/sample/pgpool.conf.sample-stream
src/test/regression/tests/001.load_balance/test.sh
src/utils/pool_select_walker.c