query logging based on views

[Chris Buxton]

There is only one logging statement, and it covers all views defined.  
There is no way to create different logging rules for different views.

You could, however, search through the query logs after the fact using  
grep to sort out just the view you want to see. (You can't do this  
live, using something like 'tail -f ... | grep ... > view.log' because  
it will fail when the query log file rolls. Unless of course you use  
logrotate to roll the logs, instead of BIND.)

Chris Buxton
Professional Services
Men & Mice

On Jun 22, 2008, at 1:55 PM, R Dicaire wrote:

> Hi folks...I saw this asked on this list back in April '08, but didnt
> see a response so I'll ask again.
>
> I'm logging client queries, and have two views configured, internal
> and external. Tailing the query log file I can now see whether the
> client query matches the internal or external view. After reading
> Bv9ARM, it doesn't seem there's a capability of logging specific
> queries based on what views were accessed. Is this in fact the case,
> and if so, is this capability going to be added in some future
> release? Is there enough demand for it?
> Thanks
>
> -- 
> aRDy Music and Rick Dicaire present:
> http://www.ardynet.com
> http://www.ardynet.com:9000/ardymusic.ogg.m3u
>