Re: How to drop user if objects depend on it

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: How to drop user if objects depend on it
Дата
Msg-id B8E81A0A8C9A4066AF62D7FE3DFCFD80@dell2
обсуждение исходный текст
Ответ на Re: How to drop user if objects depend on it  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: How to drop user if objects depend on it
Список pgsql-general
>The example script works for me.  What PG version are you running?  I have
>a vague recollection that we've fixed bugs-of-omission in DROP OWNED in
>the past.

I'm using

"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit"

In   "PostgreSQL 9.4.4, compiled by Visual C++ build 1800, 32-bit" it works.

It looks like in 9.1  reassign owned should replaced with revoke commands.

Andrus.



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

Предыдущее
От: Steve Pribyl
Дата:
Сообщение: Re: backup.old
Следующее
От: Paul Ramsey
Дата:
Сообщение: PostGIS 2.2.0 Released