On Fri, Apr 22, 2011 at 5:26 PM, Erwin Brandstetter wrote:
> Hi!
>
> It is generally not advisable to write to system catalogs directly ...
>
> 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, scatte
Simon Riggs writes:
> On Fri, Apr 22, 2011 at 5:26 PM, Erwin Brandstetter
> wrote:
>> DELETE FROM pg_description WHERE description = 'My very special
>> totally useless comment.';
> Why would you *not* use the COMMENT command for that?
If what he wants is to drop comments containing a particul
My SMB database is currently running on a HP-UX box running in a master -
slave slonyI cluster to create a hot spare database. Recently the server has
be getting hammered and we are consistently hitting our max db connections.
We have our web CMS and our web apps, our desktop client apps, and a cou
On 04/24/2011 04:21 PM, David Hornsby wrote:
> My SMB database is currently running on a HP-UX box running in a master
> - slave slonyI cluster to create a hot spare database. Recently the
> server has be getting hammered and we are consistently hitting our max
> db connections. We have our web CMS
