On Feb 19, 2015, at 3:37 PM, k...@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 _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users