Re: Enforce primary key on every table during dev?

From: Martin Moore <martin(dot)moore(at)avbrief(dot)com>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Enforce primary key on every table during dev?
Date: 2018-03-01 18:24:55
Message-ID: FEB0C7C8-E24B-4D1B-BECE-E9042B264FA5@avbrief.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2018-03-01 18:26:05 Re: Enforce primary key on every table during dev?
Previous Message Vick Khera 2018-03-01 18:20:14 Re: Version upgrade: is restoring the postgres database needed?