Re: Enforce primary key on every table during dev?

marcelo <marcelo.nicolet@gmail.com>

From: marcelo <marcelo.nicolet@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2018-03-01T20:08:57Z
Lists: 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