Re: Minor inheritance/check bug: Inconsistent behavior

On Fri, Aug 24, 2012 at 10:38 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Chris Travers <chris@metatrontech.com> writes:
>> Table inheritance would be easier if there was a way to declare a
>> constraint such that it prevents insert for some rows on the parent
>> but not for a child and/or vice versa.
>
> FWIW, 9.2 adds support for constraints that only apply to the named
> table and don't get inherited to children.  I think use of such
> constraints is probably better design than mucking around with tableoid,
> even if we were to make that work.

Maybe, but in that case shouldn't referencing a system column chuck an error?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company