SF.net SVN: ledger-smb: [2058] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 2058
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2058&view=rev
Author:   einhverfr
Date:     2008-01-20 20:23:39 -0800 (Sun, 20 Jan 2008)

Log Message:
-----------
Attaching Jeff Kowalzic's SQL cleanup patch

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2008-01-20 04:09:17 UTC (rev 2057)
+++ trunk/sql/Pg-database.sql	2008-01-21 04:23:39 UTC (rev 2058)
@@ -1066,9 +1066,9 @@
 );
 
 
-insert into transactions (id, table_name) SELECT id, 'ap' FROM ap;
+INSERT INTO transactions (id, table_name) SELECT id, 'ap' FROM ap;
 
-insert into transactions (id, table_name) SELECT id, 'ar' FROM ap;
+INSERT INTO transactions (id, table_name) SELECT id, 'ar' FROM ap;
 
 INSERT INTO transactions (id, table_name) SELECT id, 'gl' FROM gl;
 
@@ -1091,14 +1091,14 @@
 END;
 $$ LANGUAGE PLPGSQL;
 
-CREATE TRIGGER ap_track_global_sequence before insert or update on ap
-for each row execute procedure track_global_sequence();
+CREATE TRIGGER ap_track_global_sequence BEFORE INSERT OR UPDATE ON ap
+FOR EACH ROW EXECUTE PROCEDURE track_global_sequence();
 
-CREATE TRIGGER ar_track_global_sequence before insert or update on ar
-for each row execute procedure track_global_sequence();
+CREATE TRIGGER ar_track_global_sequence BEFORE INSERT OR UPDATE ON ar
+FOR EACH ROW EXECUTE PROCEDURE track_global_sequence();
 
-CREATE TRIGGER gl_track_global_sequence before insert or update on gl
-for each row execute procedure track_global_sequence();
+CREATE TRIGGER gl_track_global_sequence BEFORE INSERT OR UPDATE ON gl
+FOR EACH ROW EXECUTE PROCEDURE track_global_sequence();
 
 CREATE TABLE custom_table_catalog (
 table_id SERIAL PRIMARY KEY,


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