From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Domains vs data types |
Date: | 2025-08-20 15:43:57 |
Message-ID: | CANzqJaAK0k8A=FzL4gNmyKoHVbpA5LQVL8+=veaYBXd+i9mw8Q@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Aug 20, 2025 at 11:05 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
[snip]
>
> Personally I don't see that integer --> aint really helps.
>
No one's going to create the domain "aint", but a DB designer in a rigorous
environment _will_ create multiple, meaningfully-named domains, all of
which happen to be INTEGER. Makes large-team developing easier.
The alternative is Really Really Long column names, and consistent use of
agreed-upon suffixes.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2025-08-20 16:08:11 | Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug |
Previous Message | Adrian Klaver | 2025-08-20 15:14:47 | Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug |