Stephan Szabo <[EMAIL PROTECTED]> writes:
> ... It sounds like it'd be a pain at best.
Also, that would directly violate the SQL spec's model of dependencies,
with possibly unpleasant consequences. The current implementation does
exactly what SQL says to do. I cite from SQL99 11.99 DROP CONSTRAINT:
3) If TC is a unique constraint and RC is a referential constraint
whose referenced table is T and whose referenced columns are the
unique columns of TC, then RC is said to be dependent on TC.
...
6) If RESTRICT is specified, then:
a) No table constraint shall be dependent on TC.
NOTE 195 - If CASCADE is specified, then any such dependent
object will be dropped by the effective execution of the
<alter table statement> specified in the General Rules of this
Subclause.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
