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

2 files changed, 7 insertions, 0 deletions

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';