[marcosdumay]

On Postgres, they are. You'll get an informational message saying the index was automatically generated.

But this is not normal behavior. I think Postgres is the only one that does this.

[gurjeet]

This is not true. Even OP says so

> ... foreign keys are not indexed by default.