From 4228c08809b0ff57b13061ab0cb1d3193ba86f4c Mon Sep 17 00:00:00 2001 From: einhverfr Date: Thu, 21 Sep 2006 05:25:51 +0000 Subject: 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 --- sql/Pg-functions.sql | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'sql') 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; -- cgit v1.2.3