Re: Should this require CASCADE?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Should this require CASCADE?
Дата
Msg-id GNELIHDDFBOCMGBFGEFOOEBDCDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Should this require CASCADE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Should this require CASCADE?
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: [INTERFACES] [pgaccess-users] RE: bugzilla.pgaccess.org