Postgres Pro
Downloads
Home   >   mailing lists

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

From Rushabh Lathia
Subject Re: Primary Key Constraint on inheritance table not getting route to child tables
Date
Msg-id CAMBO3tWhV7azeyzg-gp9AY917n5YcjYjR-EY25byySOCZ2Qf4A@mail.gmail.com
Whole thread Raw
In response to Re: Primary Key Constraint on inheritance table not getting route to child tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view


On Mon, Aug 20, 2012 at 9:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 ...

Oh ok. 

Sorry for wrong noise, I was checking this on old version.

Thanks,


                        regards, tom lane



--
--
Rushabh Lathia
Technical Architect
EnterpriseDB Corporation
The Enterprise Postgres Company

Phone: +91-20-30589494

Website: http://www.enterprisedb.com

EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexpected plperl difference between 8.4 and 9.1
Next
From: Alexander Korotkov
Date:
Subject: Fix for gistchoose