[Pgpool-general] "BEGIN; LOCK TABLE" sends to slave in Master/Slave mode

[Успенский Игорь]

Hello!

I using pgpool2 v3.1 and two PostgreSQL 9.0.4 (Master/Slave with stream
replication)

Client send query "BEGIN;LOCK TABLE _1SCONNECT IN EXCLUSIVE MODE;" and
pgpool sends this query master and slave, after slave print to log
"cannot execute LOCK TABLE during recovery". Why pgpool sends this query
to slave? How to change this behavior?

My config:

-----------
listen_addresses = '*'
port = 5432
pcp_port = 9898
pcp_timeout = 10
num_init_children = 32
max_pool = 4
child_life_time = 300
connection_life_time = 0
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
debug_level = 0
pid_file_name = '/var/run/pgpool/pgpool.pid'
replication_mode = false
load_balance_mode = true
replication_stop_on_mismatch = false
replicate_select = true
reset_query_list = 'ABORT; DISCARD ALL'
print_timestamp = false
master_slave_mode = true
master_slave_sub_mode = 'stream'
delay_threshold = 0
sr_check_period = 0
sr_check_user = postgres
sr_check_password = postgres
log_standby_delay = none
connection_cache = true
health_check_timeout = 20
health_check_period = 5
health_check_user = 'postgres'
health_check_password = 'postgres'
failover_command = '/usr/local/bin/failover_stream.sh %d %
H /var/lib/pgsql/data/trigger'
failback_command = ''
fail_over_on_backend_error = true
insert_lock = false
ignore_leading_white_space = true
log_statement = false
log_per_node_statement = false
log_connections = false
log_hostname = false
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = 'T1'

backend_hostname2 = 'T2'
backend_port2 = 5432
backend_weight2 = 1
backend_data_directory2 = '/var/lib/pgsql/data'

backend_hostname3 = 'T3'
backend_port3 = 5432
backend_weight3 = 1
backend_data_directory3 = '/var/lib/pgsql/data'

enable_pool_hba = false
recovery_user = 'postgres'
recovery_password = ''
recovery_1st_stage_command = 'basebackup.sh'
recovery_2nd_stage_command = ''
recovery_timeout = 90
client_idle_limit_in_recovery = 0
lobj_lock_table = ''
-----------