[icinga-checkins] icinga.org: icinga-core/master: fix pgsql upgrade script copy paste error on dbversion (thx ttyS1) #2394

git at icinga.org git at icinga.org
Tue Apr 24 17:23:18 CEST 2012


Module: icinga-core
Branch: master
Commit: 59645a8eec31128aee5e210ea46d1aca49e8c0b8
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=59645a8eec31128aee5e210ea46d1aca49e8c0b8

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Sun Apr 22 12:13:55 2012 +0200

fix pgsql upgrade script copy paste error on dbversion (thx ttyS1) #2394

refs #2394

---

 .../db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql       |    8 ++++----
 1 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql
index a945257..ff2e34b 100644
--- a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql
+++ b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.7.0.sql
@@ -2,18 +2,18 @@
 -- upgrade path for Icinga IDOUtils 1.7.0
 --
 -- -----------------------------------------
--- Copyright (c) 2011 Icinga Development Team (http://www.icinga.org)
+-- Copyright (c) 2012 Icinga Development Team (http://www.icinga.org)
 --
 -- Please check http://docs.icinga.org for upgrading information!
 -- -----------------------------------------
 
 -- -----------------------------------------
---#2274
+-- #2274
 -- -----------------------------------------
 create index statehist_state_idx on icinga_statehistory(object_id,state);
 
 -- -----------------------------------------
---#2203 cannot handle timstamp with timezone
+-- #2203 cannot handle timstamp with timezone
 -- -----------------------------------------
 
 DROP FUNCTION from_unixtime(integer);
@@ -29,5 +29,5 @@ CREATE OR REPLACE FUNCTION unix_timestamp(timestamp with time zone) RETURNS bigi
 -- update dbversion
 -- -----------------------------------------
 
-INSERT INTO icinga_dbversion (name, version) VALUES ('idoutils', '1.7.0') ON DUPLICATE KEY UPDATE version='1.7.0';
+SELECT updatedbversion('1.7.0');
 





More information about the icinga-checkins mailing list