Re: [BUGS] attislocal value changed with the dump

2005-12-03 Thread Bruce Momjian
Is there a TODO here? --- Tom Lane wrote: > elein <[EMAIL PROTECTED]> writes: > > This is the repro with the sql file below. > > I looked into this, and the answer is you're doing it to yourself; > you shouldn't be explicit

Re: [BUGS] attislocal value changed with the dump

2005-11-05 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > This is the repro with the sql file below. I looked into this, and the answer is you're doing it to yourself; you shouldn't be explicitly re-specifying the defaults for the child columns. > create table answer_numeric ( > avalue numeric > ) inherits (an

Re: [BUGS] attislocal value changed with the dump

2005-11-04 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > This is the repro with the sql file below. FWIW, this seems to work as expected with 8.1. Don't have time to try it with 8.0 right now, but it may be an already-solved issue ... regards, tom lane ---(end of broa

Re: [BUGS] attislocal value changed with the dump

2005-11-04 Thread elein
This is the repro with the sql file below. createdb bug1 psql bug1 < qna.sql pg_dump bug1 > bug1.sql createdb bug2 psql bug2 < bug1.sql psql bug1 =# select r.relname, attname, attislocal, attinhcount from pg_attribute a join pg_class r ON (a.attrelid = r.oid) where attname = 'avid' order by rel