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

From marcelo
Subject Re: Enforce primary key on every table during dev?
Date
Msg-id e3375c58-189d-4db0-c25c-8743d22819a4@gmail.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

On 01/03/2018 16:42 , Ron Johnson wrote:
> On 03/01/2018 01:11 PM, marcelo wrote:
>>
>> On 01/03/2018 16:00 , Ron Johnson wrote:
> [snip]
>>> If your only unique index is a synthetic key, then you can insert
>>> the same "business data" multiple times with different synthetic keys.
>>>
>>>
>>> --
>>> Angular momentum makes the world go 'round.
>> IMHO, business logic can and must preclude "garbage insertion".
>> Except you are inserting data directly to database using SQL, any
>> n-tier architecture will be checking data validity.
>
> Any n-tier architecture that's bug-free.
>
Do you know about unit testing?

---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus



pgsql-general by date:

Previous
From: Daevor The Devoted
Date:
Subject: Re: Enforce primary key on every table during dev?
Next
From: Daevor The Devoted
Date:
Subject: Re: Enforce primary key on every table during dev?