Re: null values in non-nullable column

Hi, George,

"George Pavlov" <gpavlov(at)mynewplace(dot)com> wrote:

> In 8.1 I have a situation where nullability of user defined datatypes
> does not seem to be enforced. Using the following steps I end up with a
> table that has a column that should not be nullable, but has nulls in
> it.

Ouch. That hurts!

Now all those MySQL freaks can argue "Well, PostgreSQL does allow
constraint violation, too.", despite the fact that most of them don't
even basically understand the special case we have here.

So, please, keep silent about it :-)

How difficult is it to fix this (e. G. by disallowing NULL-generating
JOINs on NOT NULL domains?)

Regards,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org