[Pdns-users] Generic PostgreSQL backend ignores AAAA (IPv6) addresses

[Stephane Bortzmeyer]

I have AAAA (IPv6 addresses) in my zone file and zone2sql happily
loads them into PostgreSQL:

powerdns=# select name,type,content from records where type='AAAA';
    name    | type |           content            
------------+------+------------------------------
 ns3.nic.fr | AAAA | 2001:660:1180:1:192:134:0:49

But, when replying to a NS query, they are not loaded in the
additional section:

; <<>> DiG 9.2.1 <<>> @fr-powerdns-pgsql.dnsexp ns fr.
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 16078
;; flags: qr aa rd; QUERY: 1, ANSWER: 8, AUTHORITY: 0, ADDITIONAL: 4

;; QUESTION SECTION:
;fr.                            IN      NS

;; ANSWER SECTION:
fr.                     345600  IN      NS      ns3.domain-registry.nl.
fr.                     345600  IN      NS      ns-ext.vix.com.
fr.                     345600  IN      NS      dns.cs.wisc.edu.
fr.                     345600  IN      NS      dns.princeton.edu.
fr.                     345600  IN      NS      dns.inria.fr.
fr.                     345600  IN      NS      ns3.nic.fr.
fr.                     345600  IN      NS      ns2.nic.fr.
fr.                     345600  IN      NS      ns1.nic.fr.

;; ADDITIONAL SECTION:
dns.inria.fr.           345600  IN      A       193.51.208.13
ns3.nic.fr.             345600  IN      A       192.134.0.49
ns2.nic.fr.             345600  IN      A       192.93.0.4
ns1.nic.fr.             345600  IN      A       192.93.0.1

;; Query time: 11 msec
;; SERVER: 192.134.7.253#53(fr-powerdns-pgsql.dnsexp)
;; WHEN: Wed Mar 12 14:53:12 2003
;; MSG SIZE  rcvd: 287

PowerDNS still delivers the proper reply when asked directly for a
AAAA record. But this behaviour is annoying. Both BIND9 and nsd adds
the AAAA to the additional section.