Re: Comments on Database Broken

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patricia Holben <pholben(at)greatbridge(dot)com>
Cc: Philip Warner <pjw(at)rhyme(dot)com(dot)au>, pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: Comments on Database Broken
Date: 2001-05-21 19:30:48
Message-ID: 8437.990473448@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Patricia Holben <pholben(at)greatbridge(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-05-21 19:33:37 Re: psql dumps core when entering invalid backslash command
Previous Message Lukas Ertl 2001-05-21 19:28:57 Re: psql dumps core when entering invalid backslash command