Re: Should this require CASCADE?

Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> On Wed, 10 Jul 2002, Tom Lane wrote:
>> DROP TABLE foo RESTRICT;
>> 
>> Should this succeed?  Or should it be necessary to say DROP CASCADE to
>> get rid of the foreign-key reference to foo?

> I think the above should fail.  If someone was adding restrict since it
> was optional, I'd guess they were doing so in advance for the days when
> we'd actually restrict the drop.

Sorry if I wasn't clear: we never had the RESTRICT/CASCADE syntax at all
until now.  What I'm intending though is that DROP with no option will
default to DROP RESTRICT, which means that a lot of cases that used to
be "gotchas" will now fail until you say CASCADE.  I wrote RESTRICT in
my example just to emphasize that the intended behavior is RESTRICT.

So if you prefer, imagine same example but you merely sayDROP TABLE foo;
Does your answer change?
        regards, tom lane