Re: dropdb ; createdb equivalent without createdb permission? - Mailing list pgsql-general

From George Pavlov
Subject Re: dropdb ; createdb equivalent without createdb permission?
Date
Msg-id 8C5B026B51B6854CBE88121DBF097A86EDB779@ehost010-33.exch010.intermedia.net
Whole thread Raw
In response to Re: dropdb ; createdb equivalent without createdb permission?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> With DROP CASCADE, he can get rid of
> everything within
> the schema at a blow, so this is really pretty close to the same
> functionality.

but beware of cross-schema dependencies! e.g., a DROP SCHEMA CASCADE of
schema X containg a table that has a column defined using a domain from
schema Y will result either in that object (the domain) being dropped
from schema Y (if user has privileges on Y) or in a failure of the DROP
(if not)...

pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: Re: CASE in ORDER BY clause
Next
From: Chris
Date:
Subject: Re: What secret resipy of PostgreSQL (insert more faster than delete)?