Re: Primary Key Constraint on inheritance table not getting route to child tables

From: Rushabh Lathia <rushabh(dot)lathia(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Primary Key Constraint on inheritance table not getting route to child tables
Date: 2012-08-20 16:46:44
Message-ID: CAMBO3tWhV7azeyzg-gp9AY917n5YcjYjR-EY25byySOCZ2Qf4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Aug 20, 2012 at 9:28 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2012-08-20 16:57:20 Fix for gistchoose
Previous Message Tom Lane 2012-08-20 16:36:57 Re: Unexpected plperl difference between 8.4 and 9.1