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 _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
