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
