SF.net SVN: ledger-smb: [1896] branches/1.2/sql

[..hidden..]

Revision: 1896
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1896&view=rev
Author:   einhverfr
Date:     2007-11-23 20:59:29 -0800 (Fri, 23 Nov 2007)

Log Message:
-----------
Adding hotfix for 1819483

Added Paths:
-----------
    branches/1.2/sql/fixes/
    branches/1.2/sql/fixes/transactions_pkey_repost.sql

Added: branches/1.2/sql/fixes/transactions_pkey_repost.sql
===================================================================
--- branches/1.2/sql/fixes/transactions_pkey_repost.sql	                        (rev 0)
+++ branches/1.2/sql/fixes/transactions_pkey_repost.sql	2007-11-24 04:59:29 UTC (rev 1896)
@@ -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';


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