Postgres Pro
Downloads
Home   >   mailing lists

Re: Inherited tables and NOT NULL (pg 7.2.1) - Mailing list pgsql-general

From Tom Lane
Subject Re: Inherited tables and NOT NULL (pg 7.2.1)
Date
Msg-id 7986.1043701746@sss.pgh.pa.us
Whole thread Raw
In response to Re: Inherited tables and NOT NULL (pg 7.2.1)  ("Luke Pascoe" <luke.p@kmg.co.nz>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Chris Gamache
Date:
Subject: Re: 7.3 LOCK TABLE problem
Next
From: "Luke Pascoe"
Date:
Subject: Re: Inherited tables and NOT NULL (pg 7.2.1)