Re: Enforce primary key on every table during dev?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Enforce primary key on every table during dev?
Дата
Msg-id 796df4ca-62b8-c574-6b1b-742aa401250a@cox.net
обсуждение исходный текст
Ответ на Re: Enforce primary key on every table during dev?  (Alban Hertroys <haramrae@gmail.com>)
Ответы Re: Enforce primary key on every table during dev?
Re: Enforce primary key on every table during dev?
Список pgsql-general
On 03/01/2018 02:08 PM, marcelo wrote:
>
>
> 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?

Way Back When Dinosaurs Still Roamed The Earth and I first learned the 
trade, the focus was on proper design instead of throwing crud against the 
wall and hoping tests caught any bugs.  Because, of course, unit tests are 
only as good as you imagination in devising tests.


-- 
Angular momentum makes the world go 'round.


В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Enforce primary key on every table during dev?
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Enforce primary key on every table during dev?