Re: Make pg_dump suppress COMMENT ON SCHEMA public ? - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: Make pg_dump suppress COMMENT ON SCHEMA public ?
Date
Msg-id Pine.BSO.4.64.0801131203170.31133@leary.csoft.net
Whole thread Raw
In response to Re: Make pg_dump suppress COMMENT ON SCHEMA public ?  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Make pg_dump suppress COMMENT ON SCHEMA public ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Postgresql Materialized views
Next
From: "Merlin Moncure"
Date:
Subject: Re: Postgresql Materialized views