[pgpool-general: 8564] Re: write_function_list in 4.2 - can we use separators?

[Tatsuo Ishii]

> Thanks!
> What about using regex to specify multiple schemas in 1 pattern.
> Something like following for example:
> ((public|schema1|schema2)\.){0,1}merge_.*
> Is that possible?

That should be possible.

> Yes, I was aware of this and we plan to use it in the future.
> However, currently we have a lot of functions which perform "read
> only" work but were created without explicitly specifying function
> volatility (which then defaults VOLATILE)
> Using empty definitions in those 2 params would then cause those
> function to be sent to primary always, diluting the effectiveness of
> read load balancing (in our case)
> We plan to change these functions (there are a lot of them!) but this
> will take time and testing so for now we have to rely on the lists...

Ok, understood.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp