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

[Nick Williams]

On Feb 19, 2015, at 3:37 PM, ktm at rice.edu wrote:

> On Thu, Feb 19, 2015 at 03:34:06PM -0600, Nick Williams wrote:
>> I'm a bit curious because, looking through the code history, I can't find any evidence of it.
>> 
>> 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
>> 
>> This doesn't compute.
>> 
>> Can someone provide me some perspective on this?
>> 
>> Thanks,
>> 
>> Nick
> 
> Hi Nick,
> 
> Please check the release documentation for the new release for the schema definitions
> used and add any missing tables. The ALTER TABLE will only apply to previously existing
> tables, not create the needed new ones.
> 
> Regards,
> Ken

Ken, you misread my email. I'm not talking about adding a new table. I'm saying that apparently a new _column_ and a new _index_ was added between 3.0 and 3.1 but not listed on the 3.0 -> 3.1 upgrade instructions. Please re-read my email carefully to see the discrepancy.

Thanks,

Nick