DLZ, Bind 9.9, FreeBSD 9.2 postgresql 9.3, bind fails to start

Rod K <[email protected]> Fri, 23 Jan 2015 16:37:49 -0500
Newsgroups gmane.network.dns.bind9.dlz
Message-ID <[email protected]>
Under the above configuration Bind refuses to start but provides no 
error messages.

this is my DLZ config from named.conf:

dlz "postgres zone" {
         database "postgres 2
         {host=(hostip) dbname=(dbname) user=(user) password='(password)'}
         {select zone from dns.zones where zone='$zone$' and active='t'}
         {select ttl, type, mx_priority, case when type = 'TXT' then 
'\"; || data || '\"' else data end, resp_person, serial, refresh, 
retry,expire, minimum from dns.v_dlz
_records where zone='$zone$' and host='$record$'}
         ";
};

If I comment out the DLZ config Bind starts normally.

Can anyone point to anything I'm doing wrong?

Thanks

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet