Re: Enforce primary key on every table during dev? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Enforce primary key on every table during dev?
Date
Msg-id CAKFQuwYHAcVUkZtEpMfvHaEjv8fN418FBVizGNwgRir4n+X3tQ@mail.gmail.com
Whole thread Raw
In response to Enforce primary key on every table during dev?  (Jeremy Finzel <finzelj@gmail.com>)
List pgsql-general
On Wed, Feb 28, 2018 at 6:34 AM, Jeremy Finzel <finzelj@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.

pgsql-general by date:

Previous
From: John McKown
Date:
Subject: Re: Enforce primary key on every table during dev?
Next
From: Phil Florent
Date:
Subject: Parallel index creation & pg_stat_activity