Re: Should this require CASCADE? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Should this require CASCADE?
Date
Msg-id GNELIHDDFBOCMGBFGEFOOEBDCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Should this require CASCADE?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Jan Wieck <JanWieck@Yahoo.com> writes:
> > I think the idea was to have it default to CASCADE for this release, not
> > to break existing code right away.
>
> I never thought that.  If we default to CASCADE then a DROP is likely to
> delete stuff that it would not have deleted in prior releases.  That
> seems *far* more dangerous than "breaking existing code".  I doubt
> there's much existing code that does automatic DROPs anyway, at least
> of things that might have dependencies.

Wow - I think defaulting to CASCADE is nuts!  Surely RESTRICT should be the
safest default?

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Should this require CASCADE?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [INTERFACES] [pgaccess-users] RE: bugzilla.pgaccess.org