Re: BUG #5053: domain constraints still leak - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5053: domain constraints still leak
Date
Msg-id 603c8f070909140628l5839c3cbj6ab27ce4b5bb7352@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5053: domain constraints still leak  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5053: domain constraints still leak  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Sun, Sep 13, 2009 at 10:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Andrew Gierth" <andrew@tao11.riddles.org.uk> writes:
>> Domain NOT NULL constraints (and probably other constraints too) aren't
>> being enforced in some code paths. e.g.
>
> The example you give seems to tie really closely into the debate about
> whether a composite null is identically the same thing as ROW(NULL,NULL)
> or not. =A0In short, we have

It seems like regardless of this discussion you oughtn't to be able to
store a NULL into that table column.  But maybe I'm just confused.

...Robert

pgsql-bugs by date:

Previous
From: "Yujin"
Date:
Subject: BUG #5054: PDO -> Query returns "" from Boolean type field, if it has false value.
Next
From: Robert Haas
Date:
Subject: Re: BUG #5046: java developer