Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news.newsland.it!news.cdlan.net!ilaria.aioe.org!aioe.org!not-for-mail
From: "x" <x@not-exists.org>
Newsgroups: comp.databases.theory
Subject: Re: 'with check option' constraint
Date: Tue, 22 Nov 2005 17:02:49 +0200
Organization: Aioe.org NNTP Server
Lines: 27
Message-ID: <dlvbvm$p8i$1@domitilla.aioe.org>
References: <dlsoau$dkc$1@domitilla.aioe.org>   <1132619970.618599.260300@g49g2000cwa.googlegroups.com> <1132670086.138307.189940@g44g2000cwa.googlegroups.com>
NNTP-Posting-Host: s9btCjTiVvvsgWfav5q8uQ.719.domitilla.aioe.org
X-Complaints-To: abuse@aioe.org
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Priority: 3
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MSMail-Priority: Normal
Xref: dp-news.maxwell.syr.edu comp.databases.theory:34557


"Carl Federl" <cfederl@yahoo.com> wrote in message
news:1132670086.138307.189940@g44g2000cwa.googlegroups.com...
>
> -CELKO- wrote:
> > The WITH CHECK OPTION is not a constraint; it is part of the
> > declaration of a VIEW.  Deferring it would be a nightmare.  Do you have
> > a copy of SQL FOR SMARTIES?   I have a section on nested VIEWs with
> > various WITH CHECK OPTION [CASCADE] combinations.  It is very
> > complicated.

> Quite correct, as I confused "CHECK CONSTRAINTS" with "WITH CHECK
> OPTION"

> My prior post applies to "CHECK CONSTRAINTS" and does not apply to
> "WITH CHECK OPTION"

Thank you for the information you provided.
I think WITH CHECK OPTION is a constraint. It appears in ORACLE 9i catalog
and also has a name.
As a parallel, CHECK CONSTRAINTS are part of the declaration of a TABLE.
This does not mean they are not constraints.

Do you know of any other SQL DBMS that support deferred triggers besides
PostgreSQL ?