Showing a warning when PostgreSQL can't disable foreign key constraints

PostgreSQL can't properly disable foreign key constraints when the PostgreSQL user is not superuser. Added a warning when `ActiveRecord::InvalidForeignKey` is throw to make the user aware about the issue.

Reference #17542

---

@senny @matthewd I had technical problems with the other PR (https://github.com/rails/rails/pull/17663) and had to open another one.
you can use [`capture`](https://github.com/rails/rails/blob/master/activerecord/test/cases/test_case.rb#L16)