use BIGINT for notified_serial in pg schema; fixes #6815

[thirdparty/pdns.git] / modules / gpgsqlbackend / 4.1.0_to_4.2.0_schema.pgsql.sql

diff --git a/modules/gpgsqlbackend/4.1.0_to_4.2.0_schema.pgsql.sql b/modules/gpgsqlbackend/4.1.0_to_4.2.0_schema.pgsql.sql
index f91046250fdc2413a843b6af2ad90f11b66a8410..2333cf453599c15037ab59d72af56a68ef43b27a 100644 (file)
--- a/modules/gpgsqlbackend/4.1.0_to_4.2.0_schema.pgsql.sql
+++ b/modules/gpgsqlbackend/4.1.0_to_4.2.0_schema.pgsql.sql
@@ -1 +1,2 @@
 ALTER TABLE records DROP COLUMN change_date;
+ALTER TABLE domains ALTER notified_serial TYPE bigint USING CASE WHEN notified_serial >= 0 THEN notified_serial::bigint END;