From 4b35c768b2bcfe453d148b2fad5cd437caa5194a Mon Sep 17 00:00:00 2001 From: einhverfr Date: Mon, 21 Jan 2008 04:23:39 +0000 Subject: 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 --- sql/Pg-database.sql | 16 ++++++++-------- 1 file 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, -- cgit v1.2.3