pdnssec -all-zones command variants not working with PostgreSQL

[anon]

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.

[anon]

There's a patch available for this:  https://github.com/cyclops1982/powerdns/compare/master...472

[anon]

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.

[peter]

patch recovered, turned out to be in SVN by now!