Re: [BUGS] BUG #3973: pg_dump using inherited tables do not always restore

2008-03-03 Thread Alex Hunsaker
On Wed, Feb 20, 2008 at 3:55 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Alex Hunsaker" <[EMAIL PROTECTED]> writes: > > create table junk (val integer not null, val2 integer); > > create table junk_child () inherits (junk_1); > > alter table junk_child alter column val drop not null; > > insert

Re: [BUGS] BUG #3973: pg_dump using inherited tables do not always restore

2008-02-20 Thread Tom Lane
"Alex Hunsaker" <[EMAIL PROTECTED]> writes: > create table junk (val integer not null, val2 integer); > create table junk_child () inherits (junk_1); > alter table junk_child alter column val drop not null; > insert into junk_child (val2) values (1); > pg_dump -t junk -t junk_child > pg_restore/p