| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Ron Clarke <rclarkeai(at)gmail(dot)com> |
| Cc: | Greg Sabino Mullane <htamfids(at)gmail(dot)com>, Ertan Küçükoglu <ertan(dot)kucukoglu(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Domains vs data types |
| Date: | 2025-08-20 17:01:30 |
| Message-ID: | CAKFQuwYY0OkYMG+uuBNecaAnn7H9HFQ1NDoM3wq-pqZwdJepgg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 20, 2025 at 9:57 AM Ron Clarke <rclarkeai(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2025-08-20 17:24:29 | Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug |
| Previous Message | Ron Clarke | 2025-08-20 16:56:47 | Re: Domains vs data types |