[Pkg-pdns-maintainers] Bug#685808: pdns-backend-pgsql: add lowercase constraint for records.name to gpgsql schema (pdns-commit 2503)

[Marc Haber]

Hi,

thanks for your bugreport, which is appreciated. I do, however, need
more closer directions.

On Fri, Aug 24, 2012 at 07:50:59PM +0200, Robert Specht wrote:
> PowerDNS Authoritative Server 3.1 adds a lowercase constraint for
> records.name to gpgsql schema in commit 2503.
> 
> http://doc.powerdns.com/changelog.html#changelog-auth-3-1-1:
> "The records.name-column in the gpgsql schema is now constrained to
> lowercase, as PowerDNS would be unable to find other entries anyway.
> Fix in commit 2503, closing ticket 426."

This is http://wiki.powerdns.com/trac/changeset/2503

So you're suggesting to add
CONSTRAINT c_lowercase_name CHECK (((name)::text = lower((name)::text)))
to the CREATE TABLE statement in debian/sql/pgsql/pgsql inside the
source package, right?

You're likely to have more PostgreSQL foo than me, are there other
changes that you sugges doing? Is Debian's PostgreSQL schema correct
for dnssec? Did we miss changes that Upstream did between 2.9 and 3.1?

Greetings
Marc