SF.net SVN: ledger-smb: [74] trunk

[..hidden..]

Revision: 74
          http://svn.sourceforge.net/ledger-smb/?rev=74&view=rev
Author:   einhverfr
Date:     2006-09-12 07:46:23 -0700 (Tue, 12 Sep 2006)

Log Message:
-----------
New sl-stack changes extensions
Added parts notify trigger to pg-functions.sql

Modified Paths:
--------------
    trunk/sql/Pg-functions.sql

Added Paths:
-----------
    trunk/doc/manual/sl-stack.tex

Removed Paths:
-------------
    trunk/doc/manual/sl-stack.latex

Deleted: trunk/doc/manual/sl-stack.latex
===================================================================
--- trunk/doc/manual/sl-stack.latex	2006-09-12 14:31:43 UTC (rev 73)
+++ trunk/doc/manual/sl-stack.latex	2006-09-12 14:46:23 UTC (rev 74)
@@ -1,31 +0,0 @@
-\setlength{\unitlength}{3947sp}%
-%
-\begingroup\makeatletter\ifx\SetFigFont\undefined%
-\gdef\SetFigFont#1#2#3#4#5{%
-  ..hidden..
-  \fontfamily{#3}\fontseries{#4}\fontshape{#5}%
-  \selectfont}%
-\fi\endgroup%
-\begin{picture}(4824,4824)(3589,-5173)
-\thinlines
-{\color[rgb]{0,0,0}\put(3601,-1261){\framebox(4800,900){}}
-}%
-{\color[rgb]{0,0,0}\put(6001,-3961){\framebox(2400,1200){}}
-}%
-{\color[rgb]{0,0,0}\put(3601,-5161){\framebox(4800,1200){}}
-}%
-{\color[rgb]{0,0,0}\put(3601,-2761){\framebox(4800,1500){}}
-}%
-{\color[rgb]{0,0,0}\put(3601,-3961){\framebox(2400,1200){}}
-}%
-\put(7201,-3361){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}PostgreSQL}%
-}}}
-\put(6001,-4561){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}Operating System}%
-}}}
-\put(6001,-811){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}SQL-Ledger}%
-}}}
-\put(4201,-3361){\makebox(0,0)[lb]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}Apache}%
-}}}
-\put(6001,-1936){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}Perl}%
-}}}
-\end{picture}

Added: trunk/doc/manual/sl-stack.tex
===================================================================
--- trunk/doc/manual/sl-stack.tex	                        (rev 0)
+++ trunk/doc/manual/sl-stack.tex	2006-09-12 14:46:23 UTC (rev 74)
@@ -0,0 +1,31 @@
+\setlength{\unitlength}{3947sp}%
+%
+\begingroup\makeatletter\ifx\SetFigFont\undefined%
+\gdef\SetFigFont#1#2#3#4#5{%
+  ..hidden..
+  \fontfamily{#3}\fontseries{#4}\fontshape{#5}%
+  \selectfont}%
+\fi\endgroup%
+\begin{picture}(4824,4824)(3589,-5173)
+\thinlines
+{\color[rgb]{0,0,0}\put(3601,-1261){\framebox(4800,900){}}
+}%
+{\color[rgb]{0,0,0}\put(6001,-3961){\framebox(2400,1200){}}
+}%
+{\color[rgb]{0,0,0}\put(3601,-5161){\framebox(4800,1200){}}
+}%
+{\color[rgb]{0,0,0}\put(3601,-2761){\framebox(4800,1500){}}
+}%
+{\color[rgb]{0,0,0}\put(3601,-3961){\framebox(2400,1200){}}
+}%
+\put(7201,-3361){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}PostgreSQL}%
+}}}
+\put(6001,-4561){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}Operating System}%
+}}}
+\put(6001,-811){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}SQL-Ledger}%
+}}}
+\put(4201,-3361){\makebox(0,0)[lb]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}Apache}%
+}}}
+\put(6001,-1936){\makebox(0,0)[b]{\smash{\SetFigFont{17}{20.4}{\rmdefault}{\mddefault}{\updefault}{\color[rgb]{0,0,0}Perl}%
+}}}
+\end{picture}

Modified: trunk/sql/Pg-functions.sql
===================================================================
--- trunk/sql/Pg-functions.sql	2006-09-12 14:31:43 UTC (rev 73)
+++ trunk/sql/Pg-functions.sql	2006-09-12 14:46:23 UTC (rev 74)
@@ -252,3 +252,19 @@
 ' 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;
+  END IF;
+  RETURN NEW;
+END;
+' LANGUAGE PLPGSQL;
+
+CREATE TRIGGER parts_short AFTER UPDATE ON parts 
+FOR EACH ROW EXECUTE PROCEDURE trigger_parts_short();


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.