Unanswered: postgres trigger not working in java app -ideas???
Very puzzled...and could use any suggestions/advice to help me resolve this problemo!
Implemented a trigger for specific tables which works fine, when records are inserted, deleted or updated via the java app.
However the problem occurs when for eg deleting records from the junction tables then the main tables. Although it deletes the records, the trigger does not fire! (when it fires it should write the old record in the audit table)...Example code below:
above deletes data from junction table - trigger fired works fine-audit table has old record in it