I have a PLpgSQL AFTER UPDATE constraint trigger that calls a trigger function with an embedded select statement.
The select statement queries the affected table and returns a mult-result set that includes the record equivalent to
NEW.
However, It seems the select doesn't yet see the non-committed records. I.E. the record that should be equal to NEW is
infact equal to OLD.
Is this correct? Is there a way to adjust the visibility so that yet-to-be committed tuples are seen by the trigger
function?
Regards,
Richard Broersma Jr.