diff --git a/dns/powerdns/files/pkg-message.in b/dns/powerdns/files/pkg-message.in index 210aeb0cebcb..50c3b23624fe 100644 --- a/dns/powerdns/files/pkg-message.in +++ b/dns/powerdns/files/pkg-message.in @@ -1,63 +1,72 @@ [ { type: install message: <= 0 THEN -notified_serial::bigint END; - -This version needs a mandatory schema change for the gmsyql, godbc (mssql), gpgsql and gsqlite3 -backends. SQL statements are available in %%DOCSDIR%% or https://doc.powerdns.com +Autoserial support has been removed. The change_date column has been +removed from the records table in all gsql backends, but leaving it +in is harmless. + +The Generic PostgreSQL backend schema has changed: the notified_serial +column type in the domains table has been changed from INT DEFAULT NULL +to BIGINT DEFAULT NULL: + + ALTER TABLE domains ALTER notified_serial TYPE bigint USING CASE + WHEN notified_serial >= 0 THEN notified_serial::bigint END; + +This version needs a mandatory schema change for the gmsyql, godbc +(mssql), gpgsql, and gsqlite3 backends. SQL statements are available +in %%DOCSDIR%% or at https://doc.powerdns.com/. EOM } { type: upgrade maximum_version: "4.3.0" minimum_version: "4.2.0" message: <