summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-08-12 00:48:13 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-08-12 00:48:13 +0000
commit046aec62960a06b27e6cd624d8cd97842cbe0277 (patch)
tree1af5efc5976442d94fae2605fb3b1c32221b7302
parent315091c89469e67358649f4062264445bc6e937e (diff)
upper casing some SQL statements
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2243 4979c152-3d1c-0410-bac9-87ea11338e46
-rw-r--r--sql/Pg-database.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index aae27abc..40a1c8bf 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -578,7 +578,7 @@ 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;
CREATE RULE ap_id_track_i AS ON insert TO ap
DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ap');
@@ -586,7 +586,7 @@ DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ap');
CREATE RULE ap_id_track_u AS ON update TO ap
DO UPDATE transactions SET id = new.id WHERE id = old.id;
-insert into transactions (id, table_name) SELECT id, 'ar' FROM ap;
+INSERT INTO transactions (id, table_name) SELECT id, 'ar' FROM ap;
CREATE RULE ar_id_track_i AS ON insert TO ar
DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ar');