Ludwig Lim wrote:
Thanks, however this seems to present a different problem now.Try changing the "AFTER" to "BEFORE"CREATE TRIGGER projtask_insert_depend_trig BEFORE... Changes made to the "NEW" will not be reflect in the AFTER trigger since, the row is already inserted.
FOR dependon IN SELECT * FROM project_depend_vw
WHERE project_task_id=NEW.project_task_id LOOP
That loop apparently does not find any matching rows, which would have been inserted just before this row was, inside the same transaction.
It was successfully finding those rows before, when the trigger was AFTER INSERT. If I manually select those rows after the query is committed, I am able to pull up the matching rows.
Tim
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly