From e3e1796e7fc5cefb0ad16f3568a75a049ebe0f29 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sat, 24 Nov 2007 04:59:29 +0000 Subject: Adding hotfix for 1819483 git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1896 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/fixes/transactions_pkey_repost.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/fixes/transactions_pkey_repost.sql diff --git a/sql/fixes/transactions_pkey_repost.sql b/sql/fixes/transactions_pkey_repost.sql new file mode 100644 index 00000000..cc3935a6 --- /dev/null +++ b/sql/fixes/transactions_pkey_repost.sql @@ -0,0 +1,7 @@ + +CREATE RULE ap_track_d AS ON DELETE TO ap DO ALSO DELETE FROM transactions +WHERE id = old.id AND table_name = 'ap'; +CREATE RULE ar_track_d AS ON DELETE TO ar DO ALSO DELETE FROM transactions +WHERE id = old.id AND table_name = 'ar'; +CREATE RULE gl_track_d AS ON DELETE TO ap DO ALSO DELETE FROM transactions +WHERE id = old.id AND table_name = 'gl'; -- cgit v1.2.3