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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Primary keys and composite unique keys(basic question)
Date: 2021-04-07 16:16:48
Message-ID: 3fcf7329-378d-6982-89d9-a3f28ada0d47@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2021-04-07 16:35:55 Re: Primary keys and composite unique keys(basic question)
Previous Message PegoraroF10 2021-04-07 16:09:56 Re: Cascade publication with pg_stat_replication empty