summaryrefslogtreecommitdiff
path: root/sql/fixes/transactions_pkey_repost.sql
blob: cc3935a67182b2cf4b603df2562cffc473b9b3be (plain)
  1. CREATE RULE ap_track_d AS ON DELETE TO ap DO ALSO DELETE FROM transactions
  2. WHERE id = old.id AND table_name = 'ap';
  3. CREATE RULE ar_track_d AS ON DELETE TO ar DO ALSO DELETE FROM transactions
  4. WHERE id = old.id AND table_name = 'ar';
  5. CREATE RULE gl_track_d AS ON DELETE TO ap DO ALSO DELETE FROM transactions
  6. WHERE id = old.id AND table_name = 'gl';