summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-21 05:25:51 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-21 05:25:51 +0000
commit4228c08809b0ff57b13061ab0cb1d3193ba86f4c (patch)
tree9c7d0105e23c6e3000183579b0c063bbfe0f5a43
parent0cc84fe90078cf649fd0f09bb53cf9fd276c1972 (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-xbin/mozilla/admin.pl2
-rwxr-xr-xsql/Pg-functions.sql6
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;