Re: Enforce primary key on every table during dev?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Enforce primary key on every table during dev?
Дата
Msg-id b8800ed8-d0dc-2965-0cc7-d60fcb3d459c@cox.net
обсуждение исходный текст
Ответ на Re: Enforce primary key on every table during dev?  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general
On 03/01/2018 01:05 PM, Melvin Davidson wrote:


On Thu, Mar 1, 2018 at 2:00 PM, Ron Johnson <ron.l.johnson@cox.net> wrote:
On 03/01/2018 12:32 PM, Daevor The Devoted 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.

If you are going to go to the trouble of having a surrogate/synthetic key, then you may as well have a primary key , which is much better. 

I completely agree.

--
Angular momentum makes the world go 'round.

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

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