diff options
author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-21 05:25:51 +0000 |
---|---|---|
committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-09-21 05:25:51 +0000 |
commit | 4228c08809b0ff57b13061ab0cb1d3193ba86f4c (patch) | |
tree | 9c7d0105e23c6e3000183579b0c063bbfe0f5a43 | |
parent | 0cc84fe90078cf649fd0f09bb53cf9fd276c1972 (diff) |
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
-rwxr-xr-x | bin/mozilla/admin.pl | 2 | ||||
-rwxr-xr-x | sql/Pg-functions.sql | 6 |
2 files changed, 3 insertions, 5 deletions
diff --git a/bin/mozilla/admin.pl b/bin/mozilla/admin.pl index 5da3a86e..a6805734 100755 --- a/bin/mozilla/admin.pl +++ b/bin/mozilla/admin.pl @@ -594,7 +594,7 @@ sub form_header { <table> <tr>|; - $checked = ""; + $checked = "checked"; if ($myconfig->{dbdriver} eq $item) { 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; |