[Pdns-dev] Odd error with all-zones commands

[James Cloos]

When I try:

  :; pdnssec rectify-all-zones

I get:

  Error: Database error trying to retrieve all domains:PostgreSQL failed to execute command: 

An strace shows that the sql was sent and the reply dies include the
requested data:

  send(5, "Q\0\0\0\327select records.domain_id, records.name,
  records.content, domains.type, domains.master,
  domains.notified_serial, domains.last_check from records, domains
  where records.domain_id=domains.id and records.type='SOA'\0", 216,
  MSG_NOSIGNAL) = 216

is followed by a correct recv(5,...) with valid data, but spgsql.cc:
SPgSQL::doCommand() still throws.

Should that call use doQuery() instead?  The difference, of course, is
that doQuery() expects PGRES_TUPLES_OK whereas doCommand() expects
PGRES_COMMAND_OK.

-JimC
-- 
James Cloos <cloos at jhcloos.com>         OpenPGP: 1024D/ED7DAEA6