Re: [GENERAL] update problem in triggers

2005-09-19 Thread Tom Lane
Jamie Deppeler <[EMAIL PROTECTED]> 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. T

[GENERAL] update problem in triggers

2005-09-19 Thread Jamie Deppeler
I am having with this simple trigger i wrote, worked when i created it but now i get this error "Stack depth Limit Exceeded" If someone could tell me what i am doing wrong i would be greatfull Trigger CREATE TRIGGER "updateKeys" AFTER UPDATE ON "projects"."resource" FOR EACH ROW EXECUTE PROC