Re: how to check objects dependency??

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: how to check objects dependency??
Дата
Msg-id 20071102193052.GC2374@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: how to check objects dependency??  (Jessica Richard <rjessil@yahoo.com>)
Список pgsql-admin
Jessica Richard wrote:
> Instead of using drop user username, I used drop user "username" with
> double quotes, then the error message told me more detail about a
> specific user defined function. Then I was able to drop that function,
> then drop this user.

FYI you can use the commands DROP OWNED and REASSIGN OWNED to drop the
objects by a given role, and respectively assign them to someone else.
(8.2 only).

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alexander Lohse
Дата:
Сообщение: Problems with missing OIDs
Следующее
От: "Tena Sakai"
Дата:
Сообщение: schema privilege question