Re: Comments on Database Broken - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Comments on Database Broken
Date
Msg-id 8437.990473448@sss.pgh.pa.us
Whole thread Raw
In response to Comments on Database Broken  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Patricia Holben <pholben@greatbridge.com> writes:
> I only logged it today because I just
> realized that they didn't all come back after the dump/restore.

Hmm ... yeah, you're right, because pg_dump dumps comments along with
the objects they refer to --- and a database is not an object within
any other database.

The same would probably happen to comments on users and groups (do we
support those?).

Not clear to me if this is fixable, or worth fixing, within the
separate-dump-per-database framework of pg_dump.  Philip, any thoughts?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql dumps core when entering invalid backslash command
Next
From: Tom Lane
Date:
Subject: Re: psql dumps core when entering invalid backslash command