Marc Mamin <M.Mamin@xxxxxxxxxxxx> writes: > The test below is running fine > but if you add the trigger push_foo_tr (uncomment) > then the exception is raised. Doesn't that trigger result in infinite recursion? > CREATE OR REPLACE FUNCTION push_foo_trf () returns trigger AS $$ > BEGIN > UPDATE foo SET (id,v) = (NEW.id,NEW.v) WHERE id=NEW.id; > RETURN NEW; > END; $$ language plpgsql; > --CREATE TRIGGER push_foo_tr > -- AFTER UPDATE ON foo > -- FOR EACH ROW EXECUTE PROCEDURE check_foo_trf(); AFAICS, each trigger firing would re-queue another one because of the fresh UPDATE. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
