Re: DELETE FROM pg_description WHERE ...

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема Re: DELETE FROM pg_description WHERE ...
Дата
Msg-id 4DB35895.4040708@gmail.com
обсуждение исходный текст
Ответ на Re: DELETE FROM pg_description WHERE ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On 23.04.2011 05:21, Tom Lane wrote:
> 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
>

Thank you for your answers!

Regards
Erwin


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

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