When updating a lob column in Postgresql 9.x the trigger throws the following error.
update cr_revisions set lob = null where revision_id=14603384;
ERROR: tuple to be updated was already modified by an operation triggered by the current command
HINT: Consider using an AFTER trigger instead of a BEFORE trigger to propagate changes to other rows.
Does anyone have any idea how to fix this? It does appear to be a new change from PG 8 to PG 9.