[Pdns-users] When was ordername column added to records table?

[Nick Williams]

On Feb 19, 2015, at 3:05 PM, Christian Hofstaedtler wrote:

> 
>> On 19 Feb 2015, at 22:37, ktm at rice.edu wrote:
>> On Thu, Feb 19, 2015 at 03:34:06PM -0600, Nick Williams wrote:
>>> The schema for PDNS 3.0 shows no "ordername" column or "orderindex" index on the records table:
>>> https://github.com/PowerDNS/pdns/blob/auth-3.0/pdns/no-dnssec.schema.pgsql.sql
>>> 
>>> And the upgrade instructions for 3.0 -> 3.1 don't include an alter statement for adding the "ordername" column or "orderindex" index:
>>> https://doc.powerdns.com/md/authoritative/upgrading/#30-to-31
>>> 
>>> But the upgrade instructions for 3.1 -> 3.2 includes an alter statement for _modifying_ the "ordername" column and _dropping_ the "orderindex" index that were never added:
>>> https://doc.powerdns.com/md/authoritative/upgrading/#31-to-32
>>> 
>>> […]
> 
>>> Can someone provide me some perspective on this?
> 
> ordername was added in 3.0, as part of the DNSSEC schema upgrade. (see https://github.com/PowerDNS/pdns/blob/auth-3.0/pdns/dnssec.schema.pgsql.sql )
> 
> 
>> […] The ALTER TABLE will only apply to previously existing
>> tables, not create the needed new ones.
> 
> The upgrade SQL scripts in general add/modify tables and columns.
> 
> The instructions for upgrading to 3.4.0 include consolidated update scripts, see https://doc.powerdns.com/md/authoritative/upgrading/#database-schema .
> Pick the backend and schema type you currently have (if you come from 2.9.22, it’s always the ‘non-dnssec’ type), and you’ll end up with the correct schema.
> 
> Best,
> -- 
> Christian Hofstaedtler / Deduktiva GmbH (FN 418592 b, HG Wien)
> www.deduktiva.com / +43 1 353 1707

Thanks, Christian. Interesting that the ordername column was added in 3.0, but the schema file in the 3.0 tag (https://github.com/PowerDNS/pdns/blob/auth-3.0/pdns/no-dnssec.schema.pgsql.sql) doesn't include that column. Thanks for clearing it up from me.

Interestingly, I'm coming from 3.0.1 and my database does not have that column in it. But the consolidated script definitely helped.

Nick