Re: Enforce primary key on every table during dev?

[David G. Johnston]

On Wed, Feb 28, 2018 at 6:34 AM, Jeremy Finzel <finz...@gmail.com> wrote:

> 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.