Re: Make pg_dump suppress COMMENT ON SCHEMA public ?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Make pg_dump suppress COMMENT ON SCHEMA public ?
Date: 2008-01-13 17:05:13
Message-ID: Pine.BSO.4.64.0801131203170.31133@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 13 Jan 2008, Magnus Hagander wrote:

> Could we dump it when it's non-default only? That way the people that *have*
> set a custom comment on it will still get it restored, just a failure in this
> case. The majority of people who *haven't* set a comment will not have the
> problem at all.
>

The easiest thing to do would be to drop the default comment. Then only
custom comments would be dumped at all (at least for 8.3+ dbs). It's not
like "Standard public schema" is particularly enlightening.

Kris Jurka

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2008-01-13 17:07:50 Re: Postgresql Materialized views
Previous Message Lew 2008-01-13 17:04:29 Re: 8.2.4 serious slowdown