diff options
author | Alexander Vladishev <aleksander.vladishev@zabbix.com> | 2020-03-30 21:08:33 +0300 |
---|---|---|
committer | Alexander Vladishev <aleksander.vladishev@zabbix.com> | 2020-03-30 21:08:33 +0300 |
commit | a29a2310a5861c50f0da22d9250653dfa6e77b42 (patch) | |
tree | 066f27338d40e4c2887dd55c28bf984627c59e77 /database | |
parent | 309e90a6ad7d505db673ee50fd1085ba8656609f (diff) |
....I..... [ZBXNEXT-1736] fixed optional database upgrade patch double.sql
Diffstat (limited to 'database')
-rw-r--r-- | database/postgresql/double.sql | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/database/postgresql/double.sql b/database/postgresql/double.sql index b9570728aab..49f55c8c575 100644 --- a/database/postgresql/double.sql +++ b/database/postgresql/double.sql @@ -1,5 +1,10 @@ ALTER TABLE ONLY trends ALTER COLUMN value_min TYPE DOUBLE PRECISION, + ALTER COLUMN value_min SET DEFAULT '0.0000', ALTER COLUMN value_avg TYPE DOUBLE PRECISION, - ALTER COLUMN value_max TYPE DOUBLE PRECISION; -ALTER TABLE ONLY history ALTER COLUMN value TYPE DOUBLE PRECISION; + ALTER COLUMN value_avg SET DEFAULT '0.0000', + ALTER COLUMN value_max TYPE DOUBLE PRECISION, + ALTER COLUMN value_max SET DEFAULT '0.0000'; +ALTER TABLE ONLY history + ALTER COLUMN value TYPE DOUBLE PRECISION, + ALTER COLUMN value SET DEFAULT '0.0000'; |