Modifying table ownership

Поиск
Список
Период
Сортировка
От Paul Laub
Тема Modifying table ownership
Дата
Msg-id 002a01c17c56$590c3b10$ec02520a@incyte.com
обсуждение исходный текст
Ответы Re: Modifying table ownership  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Dear all,

When altering table ownership with

    ALTER TABLE table OWNER TO new owner

is there any way to have PostgreSQL 7.1.3 (the version I use) recursively
change
ownership of all indexes, triggers, and metadata related to or implicitly
created by
the renamed table? If not, then what is the solution? What I do now is (1) drop
indexes, (2) rename the table to table_old, (3) create a new table with desired
owner, (4) insert into table select * from table_old, and finally (5) drop
table table_old.
There has got to be an easier way.

Paul

Paul B. Laub      http://astatine.incyte.com/laub      (650) 845-5411 (voice)
Incyte Genomics, Inc.   3160 Porter Dr.  Palo Alto, CA 94304 plaub@incyte.com
                       *** Incite genomics! ***


Вложения

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

Предыдущее
От: Barry Lind
Дата:
Сообщение: Re: java stored procedures
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: DBD::ODBC and infinity timestamp