Re: [HACKERS] Dropping a schema

2002-08-21 Thread Tom Lane
Oliver Elphick <[EMAIL PROTECTED]> 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 >

Re: [HACKERS] Dropping a schema

2002-08-21 Thread Oliver Elphick
On Wed, 2002-08-21 at 15:02, Tom Lane wrote: > Oliver Elphick <[EMAIL PROTECTED]> writes: > > olly=# drop schema testing; > > NOTICE: table testing.testa depends on schema testing > > ERROR: Cannot drop schema testing because other objects depend on it > > Use DROP ... CASCADE to dro

Re: [HACKERS] Dropping a schema

2002-08-21 Thread Tom Lane
Oliver Elphick <[EMAIL PROTECTED]> writes: > olly=# drop schema testing; > NOTICE: table testing.testa depends on schema testing > ERROR: Cannot drop schema testing because other objects depend on it > Use DROP ... CASCADE to drop the dependent objects too > This seems a little ov