From: Andreas Kretschmer <andreas@a-kretschmer.de>
To: pgsql-general@lists.postgresql.org
Subject: Re: Is this a buggy behavior?
Date: Sun, 24 Mar 2024 16:36:41 +0100
Message-ID: <bf315eb3-893a-4bb4-8e4d-bb14afb29d23@a-kretschmer.de> (raw)
In-Reply-To: <eba267a8-7945-4754-bee5-6113cac477fc@gelassene-pferde.biz>
References: <CAD=mzVV6SKgj0-vO2+vx2x3qHXDw6ZCSCkm3EnAKpwkOPjUgrA@mail.gmail.com>
<yv3w7fykxqfqyio2mwentwipoojror5ebwhthpw4xfoiwaxikj@jri3ds4u7xfr>
<51eb3063-1d90-40c6-a8c6-9a77fe105a61@gelassene-pferde.biz>
<2005111.1711293431@sss.pgh.pa.us>
<eba267a8-7945-4754-bee5-6113cac477fc@gelassene-pferde.biz>
Am 24.03.24 um 16:28 schrieb Thiemo Kellner:
>
> Am 24.03.2024 um 16:17 schrieb Tom Lane:
>
>> To do that, we'd have to remember that you'd said NULL, which we
>> don't: the word is just discarded as a noise clause. Considering
>> that this usage of NULL isn't even permitted by the SQL standard,
>> that seems like a bit too much work.
>
> If I understood correctly, only the NOT NULL expression gets
> remembered, but the NULL gets discarded. No, I do not quite get it.
> Somehow, it has to be decided whether to create a "check constraint"
> or not, but this information is not available any more when creating
> the primary key? Not even in some kind of intermediary catalogue?
the null-able constraint addition to a column is pointless because by
default all columns are nullable. definition as a primary key adds the
not null constraint.
Andreas
--
Andreas Kretschmer
CYBERTEC PostgreSQL Services and Support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: andreas@a-kretschmer.de
Subject: Re: Is this a buggy behavior?
In-Reply-To: <bf315eb3-893a-4bb4-8e4d-bb14afb29d23@a-kretschmer.de>
References: <CAD=mzVV6SKgj0-vO2+vx2x3qHXDw6ZCSCkm3EnAKpwkOPjUgrA@mail.gmail.com> <yv3w7fykxqfqyio2mwentwipoojror5ebwhthpw4xfoiwaxikj@jri3ds4u7xfr> <51eb3063-1d90-40c6-a8c6-9a77fe105a61@gelassene-pferde.biz> <2005111.1711293431@sss.pgh.pa.us> <eba267a8-7945-4754-bee5-6113cac477fc@gelassene-pferde.biz> <bf315eb3-893a-4bb4-8e4d-bb14afb29d23@a-kretschmer.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox