Jamie Deppeler <jamie@doitonce.net.au> writes:
> I am having with this simple trigger i wrote, worked when i created it
> but now i get this error "Stack depth Limit Exceeded"
You've written an infinite recursion: the trigger does another UPDATE on
the same table that it is an UPDATE trigger for. The approach seems
seriously foolish in the first place --- you should be altering the NEW
record in a BEFORE trigger, not trying to change the record over again
after it's already written out.
regards, tom lane