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:[EMAIL PROTECTED]
BEGIN:VCARD
VERSION:2.1
N:Lazarus;Andrew;;;Ph.D.
FN:Andrew Lazarus, Ph.D.
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
TITLE:Director of R&D
ADR;WORK:;800-366-0688;3028 Fillmore Street;San Francisco;CA;94123;USA
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:800-366-0688=0D=0A3028 Fillmore S=
 treet=0D=0ASan Francisco=0D=0ACA=0D=0A94123=0D=0AUSA
X-GENDER:Male
REV:18991230T080000Z
END:VCARD
-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to