TLDR; I would like to get a warning on changing/adding a foreign key for Postgresql that it locks the table and if the table is large, it could be locked for some time. When adding or changing a ...

What did you expect to see? I should get an empty result set. Instead an exception is thrown, saying "SQL compilation error: show [constraint] command doesn't support this domain." A complete program ...