Re: [HACKERS] Should this require CASCADE?

2002-07-10 Thread Groff, Dana
IMHO, I believe that the standard should be adhered to if at all possible. Since Cascade was added, Restrict must be the default is my reading of the standard. So that everyone can talk from the same sheet, the 1999 SQL Standard for DROP TABLE follows: 11.20 Function Destroy a table. Format :

Re: [HACKERS] Should this require CASCADE?

2002-07-10 Thread Groff, Dana
ete: all these references are to: ISO/IEC 9075-2:1999 "Foundation" -----Original Message- From: Groff, Dana [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:30 PM To: '[EMAIL PROTECTED]' Subject: Re: [HACKERS] Should this require CASCADE? IMHO, I believe tha

Re: [HACKERS] Should this require CASCADE?

2002-07-10 Thread Groff, Dana
I think that we are getting into two or three issues here. If I may: (1) Is DROP TABLE acceptable by the standard? (2) Should we break "old" functionality? (3) assuming we support the old syntax: should DROP TABLE be functionally the same as

Re: [HACKERS] Should this require CASCADE?

2002-07-11 Thread Groff, Dana
IMHO, I believe that the standard should be adhered to if at all possible. Since Cascade was added, Restrict must be the default is my reading of the standard. So that everyone can talk from the same sheet, the 1999 SQL Standard for DROP TABLE follows: 11.20 Function Destroy a table. Format :

Re: [HACKERS] Should this require CASCADE?

2002-07-11 Thread Groff, Dana
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 12:36 PM > To: Bruce Momjian > Cc: Groff, Dana; Jan Wieck; Stephan Szabo; > [EMAIL PROTECTED] > Subject: Re: [HACKERS] Should this require CASCADE? > > > Bruce Momjian <[

Re: [HACKERS] Should this require CASCADE?

2002-07-13 Thread Groff, Dana
y requires we also support the standard syntax. Dana > -----Original Message- > From: Groff, Dana [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 12:43 PM > To: 'Tom Lane'; Bruce Momjian > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] Should this require