Re: Minor inheritance/check bug: Inconsistent behavior

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Travers <chris(at)metatrontech(dot)com>
Cc: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Minor inheritance/check bug: Inconsistent behavior
Date: 2012-08-24 14:38:27
Message-ID: 20286.1345819107@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Chris Travers <chris(at)metatrontech(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2012-08-24 14:48:09 Re: Minor inheritance/check bug: Inconsistent behavior
Previous Message Euler Taveira 2012-08-24 14:22:33 Re: BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"