Postgres Pro
Downloads
Home   >   mailing lists

Re: patch for check constraints using multiple inheritance - Mailing list pgsql-hackers

From Robert Haas
Subject Re: patch for check constraints using multiple inheritance
Date
Msg-id AANLkTimxoxPpwrw4j8wM_j2P2wM4o1_CLYgZs-D5ZrYA@mail.gmail.com
Whole thread Raw
In response to patch for check constraints using multiple inheritance  (Henk Enting <h.d.enting@mgrid.net>)
Responses Re: patch for check constraints using multiple inheritance
List pgsql-hackers
Tree view 
On Thu, Jul 29, 2010 at 6:57 AM, Henk Enting <h.d.enting@mgrid.net> wrote:
> We ran into a problem on 9.0beta3 with check constraints using table
> inheritance in a multi-level hierarchy with multiple inheritance.
>
> A test script is provided below and a proposed patch is attached to this
> email.

Thanks for the report.  This bug also appears to exist in 8.4; I'm not
sure yet how far back it goes.  I'm not so sure your proposed patch is
the right fix, though; it seems like it ought to be the job of
AddRelationNewConstraints() and MergeWithExistingConstraint() to make
sure that the right thing happens, here.

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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: reducing NUMERIC size for 9.1
Next
From: Tom Lane
Date:
Subject: Re: patch for check constraints using multiple inheritance