Re: Enforce primary key on every table during dev?

Martin Moore <martin.moore@avbrief.com>

From: Martin Moore <martin.moore@avbrief.com>
To: <pgsql-general@lists.postgresql.org>
Date: 2018-03-01T18:24:55Z
Lists: pgsql-general
 

On 03/01/2018 11:47 AM, Daevor The Devoted wrote:

>I can't stand synthetic keys.  By their very nature, they're so purposelessly arbitrary, and allow you to insert garbage into the >table.

How does not having a ‘real’ PK allow you to insert garbage and a ‘real’ one prevent garbage? 

If there’s no natural PK, at least a synthetic one will allow very quick record identification if used.

 

 

Martin.