From 2290cdcd56f56b76cc980761c61e94bbac49a085 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 6 Dec 2006 05:22:19 +0000 Subject: Applying Mads' patch to upgrade scripts git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@734 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql') diff --git a/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql b/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql index 5d3b9b9d..82da5cd6 100755 --- a/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql +++ b/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql @@ -10,7 +10,7 @@ create table recurring (id int, reference text, startdate date, nextdate date, e create table recurringemail (id int, formname text, format text, message text); create table recurringprint (id int, formname text, format text, printer text); -- -create function del_recurring() returns opaque as ' +create function del_recurring() returns trigger as ' begin delete from recurring where id = old.id; delete from recurringemail where id = old.id; -- cgit v1.2.3