Fixed custom table functions not being added.

Fixed parts short trigger not being creted
Pg option in new user creation is now checked by default.


git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@127 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 2 insertions, 4 deletions

diff --git a/sql/Pg-functions.sql b/sql/Pg-functions.sql
index ee70b0e7..c11def4d 100755
--- a/sql/Pg-functions.sql
+++ b/sql/Pg-functions.sql
@@ -249,15 +249,13 @@ BEGIN
 
 RETURN v_cost;
 END;
-' language 'plpgsql';
+' language plpgsql;
 -- end function
 --
-CREATE OR REPLACE FUNCTION trigger_parts_short() RETURNS TRIGGER
-AS
-'
 
 CREATE OR REPLACE FUNCTION trigger_parts_short() RETURNS TRIGGER
 AS
+'
 BEGIN
   IF NEW.onhand >= NEW.rop THEN
     NOTIFY parts_short;