Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Should this require CASCADE?
Date
Msg-id 13325.1026358280@sss.pgh.pa.us
Whole thread Raw
In response to Re: Should this require CASCADE?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Should this require CASCADE?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Sounds good to me, and I don't think we need to require RESTRICT just
> because the standard says so.  Does the standard require RESTRICT for
> every DROP or just drops that have foreign keys?

Syntactically, it requires RESTRICT or CASCADE on *every* form of DROP.
I don't think we're willing to do that...
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Should this require CASCADE?
Next
From: Bruce Momjian
Date:
Subject: Re: Should this require CASCADE?