Home > mailing lists

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

From	Martin Moore
Subject	Re: Enforce primary key on every table during dev?
Date	March 2, 2018 00:24:55
Msg-id	FEB0C7C8-E24B-4D1B-BECE-E9042B264FA5@avbrief.com Whole thread Raw
In response to	Re: Enforce primary key on every table during dev? (Ron Johnson <ron.l.johnson@cox.net>)
List	pgsql-general

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

From: Vick Khera
Date: 02 March 2018, 00:20:14
Subject: Re: Version upgrade: is restoring the postgres database needed?

From: Francisco Olarte
Date: 02 March 2018, 00:26:05
Subject: Re: Enforce primary key on every table during dev?