Re: NOT NULL constrinat lost in VIEW after cast

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 23 May 2007 05:49:33 -0700
Message-ID: <1179924573.576297.157580@k79g2000hse.googlegroups.com>

On May 23, 12:12 pm, andi..._at_gmx.net wrote:
> On 23 Mai, 08:40, Thomas Kellerer <JUAXQOSZF..._at_spammotel.com> wrote:
>
> > [...]
>
> > I don't see the problem.
> > As long as the view is not updatable it doesn't matter whether the
> > column is NOT NULL.
>
> > Thomas
>
> its not really a problem for me, but for the customer. if the customer
> can see the NOT NULL constraint, he can be sure that he will be
> receiving no NULL values for that column, which could cause failures
> in his processes.
>
> AndiZed

You can't have NOT NULL constraints on a VIEW column. This constraint is enforced on base table level, and your customer can always check the view definition to make sure that the view's subquery is constructed such that it can't introduce NULL values itself.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Wed May 23 2007 - 07:49:33 CDT