From 901b9d2bd5c402e45526e151604afd119c6e0ec1 Mon Sep 17 00:00:00 2001
From: alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Fri, 22 Jun 2007 18:12:58 +0000
Subject:  - fixed PostgreSQL upgrade patch (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@4353 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 upgrades/dbpatches/1.4/postgresql/patch/triggers.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'upgrades/dbpatches/1.4/postgresql/patch/triggers.sql')

diff --git a/upgrades/dbpatches/1.4/postgresql/patch/triggers.sql b/upgrades/dbpatches/1.4/postgresql/patch/triggers.sql
index 57c348d0..fa1b3323 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/triggers.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/triggers.sql
@@ -12,7 +12,7 @@ CREATE TABLE triggers_tmp (
 	error		varchar(128)		DEFAULT ''	NOT NULL,
 	templateid	bigint DEFAULT '0'	NOT NULL,
 	PRIMARY KEY (triggerid)
-);
+) with OIDS;
 CREATE INDEX triggers_1 on triggers_tmp (status);
 CREATE INDEX triggers_2 on triggers_tmp (value);
 
-- 
cgit