Marc Mamin <M(dot)Mamin(at)intershop(dot)de> 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