Request a Demo
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Domains vs data types
Date
Msg-id CAKFQuwYY0OkYMG+uuBNecaAnn7H9HFQ1NDoM3wq-pqZwdJepgg@mail.gmail.com
Whole thread Raw
In response to Re: Domains vs data types  (Ron Clarke <rclarkeai@gmail.com>)
List pgsql-general
Tree view
On Wed, Aug 20, 2025 at 9:57 AM Ron Clarke <rclarkeai@gmail.com> wrote:
...and ensure the same defaults, nulls etc are applied accross tables.

Just as a warning - a deviation we have from the SQL Standard regarding domains and their NOT NULL constraints makes specifying one on a domain a bit of a potential trap.  Rely on column NOT NULL.

David J.

pgsql-general by date:

Previous
From: Ron Clarke
Date:
Subject: Re: Domains vs data types
Next
From: Rob Sargent
Date:
Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug