Re: Inherited tables and NOT NULL (pg 7.2.1)

"Luke Pascoe" <luke.p@kmg.co.nz> writes:
> temp=> ALTER TABLE parent ADD CONSTRAINT ccc_nn CHECK (ccc IS NOT NULL);
> ERROR:  cache lookup of attribute 3 in relation 70023 failed

What version did you say you were running?  It works fine for me in 7.3.
I can believe this has been broken in the past, though.

            regards, tom lane