[icinga-checkins] icinga.org: icinga-core/master: change pgsql create function language to lowercase/nonquoted for 9.2 ( fixes #3308)

git at icinga.org git at icinga.org
Wed Oct 17 12:37:46 CEST 2012


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

Author: Michael Friedrich <michael.friedrich at gmail.com>
Date:   Wed Oct 17 12:36:49 2012 +0200

change pgsql create function language to lowercase/nonquoted for 9.2 (fixes #3308)

---

 module/idoutils/db/pgsql/pgsql.sql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/module/idoutils/db/pgsql/pgsql.sql b/module/idoutils/db/pgsql/pgsql.sql
index 95adad4..6c21303 100644
--- a/module/idoutils/db/pgsql/pgsql.sql
+++ b/module/idoutils/db/pgsql/pgsql.sql
@@ -15,11 +15,11 @@
 
 CREATE OR REPLACE FUNCTION from_unixtime(integer) RETURNS timestamp with time zone AS '
          SELECT to_timestamp($1) AS result
-' LANGUAGE 'SQL';
+' LANGUAGE sql;
 
 CREATE OR REPLACE FUNCTION unix_timestamp(timestamp with time zone) RETURNS bigint AS '
         SELECT EXTRACT(EPOCH FROM $1)::bigint AS result;
-' LANGUAGE 'SQL';
+' LANGUAGE sql;
 
 
 -- -----------------------------------------





More information about the icinga-checkins mailing list