Postgres Pro
Downloads
Home   >   mailing lists

Thread: Add CASCADE to DROP SCHEMA, please

Add CASCADE to DROP SCHEMA, please

From
"Andrus"
Date:
Currently pgAdmin allows to delete only emtpry schemas.

Can you add CASCADE clause to the DROP SCHEMA statement which pgAdmin 
generates so that non-empty schemas can be deleted also, please.


Andrus

Re: Add CASCADE to DROP SCHEMA, please

From
"Dave Page"
Date:

> ------- Original Message -------
> From: "Andrus" <eetasoft@online.ee>
> To: pgadmin-support@postgresql.org
> Sent: 25/11/06, 19:41:10
> Subject: [pgadmin-support] Add CASCADE to DROP SCHEMA, please
> 
> Currently pgAdmin allows to delete only emtpry schemas.
> 
> Can you add CASCADE clause to the DROP SCHEMA statement which pgAdmin 
> generates so that non-empty schemas can be deleted also, please.
> 

pgAdmin already has a "Drop Cascaded" option that works for schemas. Just right-click the object to drop.

Regards, Dave

Re: Add CASCADE to DROP SCHEMA, please

From
Dave Page
Date:
Andrus wrote:
>> pgAdmin already has a "Drop Cascaded" option that works for schemas. 
>> Just right-click the object to drop.
> 
> Dave,
> 
> thank you. It works.
> 
> I expected that Del command runs drop cascaded .
> 
> It would be better to make drop always cascaded.
> This would allow to remove drop cascaded menu item and makes pgAdmin 
> usage simpler.

That would be akin to making 'rm -r' the default on a Unix system (or 
make DROP...CASCADE' the default in SQL) - I'd rather not load that 
particular footgun.

Regards, Dave