Attaching Jeff Kowalzic's SQL cleanup patch

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2058 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 8 insertions, 8 deletions

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 866a89f3..d5d182dd 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -1066,9 +1066,9 @@ CREATE TABLE jcitems (
 );
 
 
-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 @@ BEGIN
 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,