Re: dropdb ; createdb equivalent without createdb permission?

Поиск
Список
Период
Сортировка
От George Pavlov
Тема Re: dropdb ; createdb equivalent without createdb permission?
Дата
Msg-id 8C5B026B51B6854CBE88121DBF097A86EDB779@ehost010-33.exch010.intermedia.net
обсуждение исходный текст
Ответ на Re: dropdb ; createdb equivalent without createdb permission?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Uwe C. Schroeder"
Дата:
Сообщение: Re: CASE in ORDER BY clause
Следующее
От: Chris
Дата:
Сообщение: Re: What secret resipy of PostgreSQL (insert more faster than delete)?