Re: DELETE FROM pg_description WHERE ... - Mailing list pgsql-admin

From Erwin Brandstetter
Subject Re: DELETE FROM pg_description WHERE ...
Date
Msg-id 4DB35895.4040708@gmail.com
Whole thread Raw
In response to Re: DELETE FROM pg_description WHERE ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: bo gu
Date:
Subject: a warm standby takes over, hot standby does not catch up
Next
From: Craig James
Date:
Subject: Re: select for update