Postgres Pro
Downloads
Home   >   mailing lists

Re: Primary Key Constraint on inheritance table not getting route to child tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Primary Key Constraint on inheritance table not getting route to child tables
Date
Msg-id 1457.1345478287@sss.pgh.pa.us
Whole thread Raw
In response to Primary Key Constraint on inheritance table not getting route to child tables  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Responses Re: Primary Key Constraint on inheritance table not getting route to child tables
List pgsql-hackers
Tree view 
Rushabh Lathia <rushabh.lathia@gmail.com> writes:
> ALTER TABLE ADD Constraints PRIMARY KEY on inheritance table not getting
> route to child table.

Right.

> But when we do ALTER TABLE DROP Constraint on the same, it complains about
> constraint does not exists on child table.

Works for me in HEAD.  What version are you testing?  This seems related
to some recent bug fixes ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: The pgrminclude problem
Next
From: Alex Hunsaker
Date:
Subject: Re: Unexpected plperl difference between 8.4 and 9.1