Re: DELETE FROM pg_description WHERE ...

From: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DELETE FROM pg_description WHERE ...
Date: 2011-04-23 22:54:13
Message-ID: 4DB35895.4040708@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 23.04.2011 05:21, Tom Lane wrote:
> Erwin Brandstetter<brsaweda(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2011-04-24 00:49:09 Re: select for update
Previous Message bo gu 2011-04-23 09:40:59 a warm standby takes over, hot standby does not catch up