We want to enforce a policy, partly just to protect those who might forget, for every table in a particular schema to have a primary key. This can't be done with event triggers as far as I can see, because it is quite legitimate to do:
Add a query to your test suite that queries the catalogs and fails if this policy is violated. There is nothing in a running PostgreSQL server instance that is going to enforce this for you.
David J.
