[pgpool-general: 1510] black_function_list & function

[i.marchionni]

Hi, 
 
I hav a problem with function that modify database... 
 
My config is Pgpool 3.1.3 in master/slave configuration  whit streaming replication. I try configure "black_function_list" black_function_list = 
'currval,lastval,nextval,setval,AddGeometryColumn,Fix_Geometry_Columns,UpdateGeometrySRID,Populate_Geometry_Columns,Probe_Geometry_Columns,DropGeometryTable,DropGeometryColumni,sde_table_lock_def_delete,sde_table_lock_def_insert,sde_layer_lock_def_delete_user,sde_logfiles'
 and if I correctly understand doc all function in black_list must be routed do master. But in slave postgres logfile i found 
 
26696 2013-03-18 11:39:23 CET ERROR:  cannot execute DELETE in a read-only transaction26696 2013-03-18 11:39:23 CET CONTEXT:  SQL statement "DELETE FROM geoportale.sde.sde_table_locks WHERE sde_id = i_sde_id                           AND registration_id = i_registration_id"        PL/pgSQL function "sde_table_lock_def_delete" line 6 at SQL statement        SQL statement "SELECT                 geoportale.sde.SDE_table_lock_def_delete(i_sde_id, i_registration_id)"        PL/pgSQL function "sde_table_lock_def_insert" line 9 at SQL statement
what's goes wrong?? 
 
Thank's for help 
 
Best Regard'sItalo
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130318/8f1dad91/attachment.html>