"Dmitry Koterov" <dmitry(at)koterov(dot)ru> writes:
> CREATE TRIGGER t000_set_id
> - BEFORE INSERT OR DELETE OR UPDATE ON a
> + BEFORE INSERT OR DELETE OR UPDATE ON b
> FOR EACH ROW
> EXECUTE PROCEDURE i_trg();
> CREATE TRIGGER t000_set_id
> - BEFORE INSERT OR DELETE OR UPDATE ON b
> + BEFORE INSERT OR DELETE OR UPDATE ON a
> FOR EACH ROW
> EXECUTE PROCEDURE i_trg();
> You see, object names are the same, but ordering is mixed.
Yeah, because the sort is just on object name.
For objects of the same type I suppose we could take a look at their
owning object's name too ...
regards, tom lane