document gsql change_date removal and pgsql type change

diff --git a/docs/upgrading.rst b/docs/upgrading.rst
index 622d1087d14358e7738bad550550a8b7386c8c5e..19d1f8aa7b0c2c360c696d501f38c82110e55f82 100644 (file)
--- a/docs/upgrading.rst
+++ b/docs/upgrading.rst
@@ -13,6 +13,8 @@ upgrade notes if your version is older than 3.4.2.
 
 - Superslave operation is no longer enabled by default, use :ref:`setting-superslave` to enable. This setting was called ``supermaster`` in some 4.2.0 prereleases.
 - The gsqlite3 backend, and the DNSSEC database for the BIND backend, have a new journal-mode setting. This setting defaults to `WAL <https://www.sqlite.org/wal.html>`_; older versions of PowerDNS did not set the journal mode, which means they used the SQLite default of DELETE.
+- Autoserial support has been removed. The ``change_date`` column has been removed from the ``domains`` table in all gsql backends, but leaving it in is harmless.
+- The :doc:`Generic PostgreSQL backend <backends/generic-postgresql>` 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;``
 
 4.1.0 to 4.1.1
 --------------