Re: Dropping a schema

Oliver Elphick <olly@lfix.co.uk> writes:
> On Wed, 2002-08-21 at 15:02, Tom Lane wrote:
>> Also, it seems the safest behavior to me.  "rmdir dir" won't remove a
>> nonempty directory; isn't that a pretty close analogy?

> Not really, seeing that you can't say "mkdir directory (containing these
> files)".  An implicit cascade *inside* the schema seems an appropriate
> parallel to "CREATE SCHEMA ... (CREATE TABLE ...)".  After all, we don't
> have to say "DROP TABLE ... CASCADE" because the table has rows in it!

Hm.  I could see an argument for being willing to auto-drop stuff that
had been made that way (inside CREATE SCHEMA) but not stuff that was
made by separate commands.  But the spec doesn't seem to make any such
distinction: RESTRICT is RESTRICT.  In any case, I like the behavior as
it is, so I'm not gonna go out of my way to change it...
        regards, tom lane