Re: Inherited tables and NOT NULL (pg 7.2.1)

7.2.1 - I guess I should upgrade/build, but I've been made slack by apt :-)

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Luke Pascoe" <luke(dot)p(at)kmg(dot)co(dot)nz>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, January 28, 2003 10:09 AM
Subject: Re: [GENERAL] Inherited tables and NOT NULL (pg 7.2.1)

> "Luke Pascoe" <luke(dot)p(at)kmg(dot)co(dot)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
>
>