Обсуждение: pg_dump, COPY and inheritance

I was surprised to find out that in my pg_dumpall, inherited tables
(which have no extra columns) come out empty. All of the data are in
the base table. I was doing a dump to upgrade from 8.2 to 8.3, and
this means that I have to split the base table up by hand. (Constraint
exclusion on child tables is very useful in the domain.)

Shouldn't pg_dump do a (not yet implemented)

COPY ONLY basetable TO stdout ?
COPY ONLY childtable TO stdout ?



--
Sincerely,
 Andrew Lazarus                         mailto:andrew@pillette.com

Andrew Lazarus <andrew@pillette.com> writes:
> I was surprised to find out that in my pg_dumpall, inherited tables
> (which have no extra columns) come out empty. All of the data are in
> the base table.

Well, then, that's where the data was in the source database.  I can
assure you pg_dump has gotten this right for many years.

            regards, tom lane