Re: Minor inheritance/check bug: Inconsistent behavior - Mailing list pgsql-bugs

From Robert Haas
Subject Re: Minor inheritance/check bug: Inconsistent behavior
Date
Msg-id CA+TgmoZg1SXqtFmGQ8qH_kiWVF5AOuM6GxdTpA=GuUYaBm0LEA@mail.gmail.com
Whole thread Raw
In response to Re: Minor inheritance/check bug: Inconsistent behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Minor inheritance/check bug: Inconsistent behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #7507: pg_restore silently fails when restoring a db with the --create flag and no user.
Next
From: Tom Lane
Date:
Subject: Re: Minor inheritance/check bug: Inconsistent behavior