Re: Primary keys and composite unique keys(basic question)

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Primary keys and composite unique keys(basic question)
Дата
Msg-id 09cdd33e-24ed-f51c-84fd-1955c42a0d84@gmail.com
обсуждение исходный текст
Ответ на Re: Primary keys and composite unique keys(basic question)  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
On 4/7/21 1:16 PM, Rob Sargent wrote:
On 4/7/21 11:59 AM, Ron wrote:
On 4/7/21 11:35 AM, Rob Sargent wrote:

On Apr 7, 2021, at 10:17 AM, Ron <ronljohnsonjr@gmail.com> wrote:

 On 4/5/21 9:37 PM, Rob Sargent wrote:
It's a small thing, but UUIDs are absolutely not memorizable by
humans; they have zero semantic value.  Sequential numeric identifiers
are generally easier to transpose and the value gives some clues to
its age (of course, in security contexts this can be a downside).

I take the above as a definite plus.  Spent too much of my life correcting others’ use of “remembered” id’s that just happened to perfectly match the wrong thing.

People seem to have stopped appending check digits to identifiers about 20 years ago, and I'm not sure why.

No the problem is “start from one”. User has item/I’d 10875 in hand and types in 10785 which of course in a sequence supplied ID steam is perfectly valid and wrong.  Really hard to track down.

That's my point.  Adding a check digit (turning 10875 into 108753) would have caught that, since 107853 does not match 107854 (which is 10785 with a check digit added).
Well you forget that 108753 is also a number in the series from 1 to maxint.   Maybe you're on to something though: a checksum dispensing sequence!

Call a function which reads the next value from the sequence, appends the check digit and returns that number.  We were doing that 25 years ago.

--
Angular momentum makes the world go 'round.

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Primary keys and composite unique keys(basic question)
Следующее
От: Jagmohan Kaintura
Дата:
Сообщение: could not receive data from client: Connection reset by peer