[runeks]

> […] but also because they can result in incorrect joins.

Side question: can I get Postgres to throw an error if I try to join on two IDs where neither of the IDs have a foreign key reference to the other?

[sk5t]

I wouldn't think so, and this sounds like a mighty footgun!