iakio/pgpool-II — Issue #1: Invalid regex pattern in black_function_list value
Author: sdecleire
Created: 2011-11-20 21:09:07+00:00
State: open

Hi,

I encounter an error that i can't bypass anytime the value of the PGPool-II configuration file "black_function_list" is not empty.

With the configuration below :

white_function_list = ''
# Comma separated list of function names
# that don't write to database
# Regexp are accepted
black_function_list = 'nextval'
# Comma separated list of function names
# that write to database
# Regexp are accepted

I get the following error :

Nov 20 17:20:41 data1 pgpool[63623]: add_to_patterns: invalid regex pattern: ^nextval$

My environment is the following :
PostgreSQL 9.1.1_1 / PGPool -II v3.1 on FreeBSD 8.2

I have tried to modify the value of the black_function_list
'^nextval$' gives the same error
and it seems that any regular expression (i have just tried ^.*$) gives also the same error.

Thanks in advance for any clue.