[GENERAL] pg_dump, COPY and inheritance

2008-06-09 Thread Andrew Lazarus
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

Re: [GENERAL] pg_dump, COPY and inheritance

2008-06-09 Thread Tom Lane
Andrew Lazarus [EMAIL PROTECTED] 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