I installed this branch on my 3.0.2(-ish) database and the migration went well. However, when I attempted a purge of circulations, I got this:
ERROR: update or delete on table "billing" violates foreign key constraint "account_adjustment_billing_fkey" on table "account_adjustment"
DETAIL: Key (id)=(225414351) is still referenced from table "account_adjustment".
CONTEXT: SQL statement "DELETE FROM money.billing WHERE xact = OLD.id"
PL/pgSQL function action.age_circ_on_delete() line 44 at SQL statement
SQL statement "DELETE FROM action.circulation WHERE id = circ_chain_tail.id"
PL/pgSQL function action.purge_circulations() line 74 at SQL statement
Does we need an aging table for money.account_adjustment too?
I installed this branch on my 3.0.2(-ish) database and the migration went well. However, when I attempted a purge of circulations, I got this:
ERROR: update or delete on table "billing" violates foreign key constraint "account_ adjustment_ billing_ fkey" on table "account_ adjustment" adjustment" . age_circ_ on_delete( ) line 44 at SQL statement purge_circulati ons() line 74 at SQL statement
DETAIL: Key (id)=(225414351) is still referenced from table "account_
CONTEXT: SQL statement "DELETE FROM money.billing WHERE xact = OLD.id"
PL/pgSQL function action.
SQL statement "DELETE FROM action.circulation WHERE id = circ_chain_tail.id"
PL/pgSQL function action.
Does we need an aging table for money.account_ adjustment too?