Hi All,
how i write this trigger in postgresql 9.3 in postgresql 9.0 it is running well
i had transaction header and transaction detail table
I had trigger on after detail table inserted, updated, or deleted it update value on header table
when header is deleted i had trigger that run in before delete event to delete the detail table.
i need header run in before event because when detail is deleted(or update and insert) and the trigger is running i need selecting data from header.
now in postgresql 9.3 i get this error "tuple to be updated was already modified by an operation triggered by current command", it running well in 9.0
there is hint that said "Consider using an AFTER trigger instead of a before trigger to propagate changes to other row", i cannot use after trigger because i need selecting data from header when detail trigger is fired.
any idea how i should do this on postgresql 9.3
Best Regards,
Erwan Tanajaya
Sorry for my bad english