From 5cf7df87f87c8333dd6deab69af218e37970bc94 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sat, 23 Sep 2006 06:03:43 +0000 Subject: Fixed issues with the creation of function in the upgrade scripts and function files git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@136 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-functions.sql | 4 ++++ sql/Pg-upgrade-2.6.17-2.6.18.sql | 3 +++ 2 files changed, 7 insertions(+) (limited to 'sql') diff --git a/sql/Pg-functions.sql b/sql/Pg-functions.sql index c11def4d..26d23473 100755 --- a/sql/Pg-functions.sql +++ b/sql/Pg-functions.sql @@ -263,9 +263,11 @@ BEGIN RETURN NEW; END; ' LANGUAGE PLPGSQL; +-- end function CREATE TRIGGER parts_short AFTER UPDATE ON parts FOR EACH ROW EXECUTE PROCEDURE trigger_parts_short(); +-- end function CREATE OR REPLACE FUNCTION add_custom_field (VARCHAR, VARCHAR, VARCHAR) RETURNS BOOL AS @@ -296,6 +298,7 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function CREATE OR REPLACE FUNCTION drop_custom_field (VARCHAR, VARCHAR) RETURNS BOOL AS @@ -313,3 +316,4 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function diff --git a/sql/Pg-upgrade-2.6.17-2.6.18.sql b/sql/Pg-upgrade-2.6.17-2.6.18.sql index 39c726b6..b18e327e 100644 --- a/sql/Pg-upgrade-2.6.17-2.6.18.sql +++ b/sql/Pg-upgrade-2.6.17-2.6.18.sql @@ -94,6 +94,7 @@ BEGIN RETURN NEW; END; ' LANGUAGE PLPGSQL; +-- end function CREATE TRIGGER parts_short AFTER UPDATE ON parts FOR EACH ROW EXECUTE PROCEDURE trigger_parts_short(); @@ -263,6 +264,7 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function CREATE OR REPLACE FUNCTION drop_custom_field (VARCHAR, VARCHAR) RETURNS BOOL AS @@ -280,5 +282,6 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function UPDATE defaults SET version = '2.6.18'; -- cgit v1.2.3