summaryrefslogtreecommitdiff
path: root/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-12-06 05:22:19 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-12-06 05:22:19 +0000
commit2290cdcd56f56b76cc980761c61e94bbac49a085 (patch)
treeb45ee560020171beefda5054bc8072d4d4fca0fc /sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
parent5a732a5df81bc761b914189f5f29cf4831343c90 (diff)
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
Diffstat (limited to 'sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql')
-rwxr-xr-xsql/legacy/Pg-upgrade-2.3.9-2.4.2.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql b/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
index 4e91e473..92096fbe 100755
--- a/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
+++ b/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
@@ -4,7 +4,7 @@ drop trigger del_vendor on vendor;
drop function del_customer();
drop function del_vendor();
--
-create function del_customer() returns opaque as '
+create function del_customer() returns trigger as '
begin
delete from shipto where trans_id = old.id;
delete from customertax where customer_id = old.id;
@@ -17,7 +17,7 @@ end;
create trigger del_customer after delete on customer for each row execute procedure del_customer();
-- end trigger
--
-create function del_vendor() returns opaque as '
+create function del_vendor() returns trigger as '
begin
delete from shipto where trans_id = old.id;
delete from vendortax where vendor_id = old.id;