Jamie Deppeler <jamie@xxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
