Re: Inherited tables and NOT NULL (pg 7.2.1)

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>
Subject: Re: Inherited tables and NOT NULL (pg 7.2.1)
Date: 2003-01-27 21:09:06
Message-ID: 7986.1043701746@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2003-01-27 21:12:09 Re: Indexing foreign keys
Previous Message Peter Eisentraut 2003-01-27 21:08:55 Re: JDBC driver