Re: DELETE FROM pg_description WHERE ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DELETE FROM pg_description WHERE ...
Дата
Msg-id 1237.1303528918@sss.pgh.pa.us
обсуждение исходный текст
Ответ на DELETE FROM pg_description WHERE ...  (Erwin Brandstetter <brsaweda@gmail.com>)
Ответы Re: DELETE FROM pg_description WHERE ...
Список pgsql-admin
Erwin Brandstetter <brsaweda@gmail.com> writes:
> However, I have a database with dozens of schemas and hundreds of
> tables. There is a bunch of useless comments on columns I want to get
> rid of, scattered all across the db. The fastest & easiest way would
> be:

> DELETE FROM pg_description WHERE description = 'My very special
> totally useless comment.';

> AFAICS, there are no side-effects. Are there any?

It's safe enough, as long as you don't delete the wrong comments.
There's no hidden infrastructure for a comment.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: select for update
Следующее
От: bo gu
Дата:
Сообщение: a warm standby takes over, hot standby does not catch up