Re: Domains vs data types - Mailing list pgsql-general

From Ron Johnson
Subject Re: Domains vs data types
Date
Msg-id CANzqJaAK0k8A=FzL4gNmyKoHVbpA5LQVL8+=veaYBXd+i9mw8Q@mail.gmail.com
Whole thread Raw
In response to Re: Domains vs data types  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Wed, Aug 20, 2025 at 11:05 AM Adrian Klaver <adrian.klaver@aklaver.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!

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug