Bind and DLZ strange loop
Job
Job at colliniconsulting.it
Wed Sep 7 15:45:32 UTC 2016
Hello,
we use Bind with DLZ, Postgres 8.4.8 as RDBMS support.
Everything works but, with DLZ query, i notice (in Postsgresql log), that Bind calls two times the same queries.
For example, to resolve with Bind-DLZ www.fiorino.it, it should make three queries (to descend until Top level domain):
www.fiorino.it
fiorino.it
it
Instead of this, it repeat the queries two times:
first time <2016-09-07 17:36:56 CEST>LOG: duration: 0.965 ms statement: select 'www.fiorino.it' where function_cloud_view_orari('53', x.x.x.x, 'www.fiorino.it') != '';
first time <2016-09-07 17:36:56 CEST>LOG: duration: 0.359 ms statement: select 'fiorino.it' where function_cloud_view_orari('53', x.x.x.x, 'fiorino.it') != '';
first time <2016-09-07 17:36:56 CEST>LOG: duration: 0.304 ms statement: select 'it' where function_cloud_view_orari('53', x.x.x.x, 'it') != '';
second time <2016-09-07 17:36:56 CEST>LOG: duration: 0.291 ms statement: select 'www.fiorino.it' where function_cloud_view_orari('53', x.x.x.x, 'www.fiorino.it') != '';
second time <2016-09-07 17:36:56 CEST>LOG: duration: 0.291 ms statement: select 'fiorino.it' where function_cloud_view_orari('53', x.x.x.x, 'fiorino.it') != '';
second time <2016-09-07 17:36:56 CEST>LOG: duration: 0.215 ms statement: select 'it' where function_cloud_view_orari('53', x.x.x.x, 'it') != '';
Can someone help me with?
Thank you!
Francesco
More information about the bind-users
mailing list