Re: Predictable order of SQL commands in pg_dump

"Dmitry Koterov" <dmitry@koterov.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