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

[HACKERS] Dropping a schema

2002-08-20 Thread Oliver Elphick
I had a test schema containing one table. 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 over-rest