When running any of the -all-zones command of pdnssec I receive the following error message:
Error: Database error trying to retrieve all domains:PostgreSQL failed to execute command:
Adding the gpgsql-get-all-domains-query to the config did not help as well. Running pdnssec check-zone against a zone explicitly however does work.
There's a patch available for this:
Just a note, the above patch file is missing from the referenced location.
If someone can recover it, it's probably better to attach a patch file directly to this ticket.
patch recovered, turned out to be in SVN by now!