Skip site navigation (1) Skip section navigation (2)

Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraintdoes not work on inherited master table

From: Amit kapila <amit(dot)kapila(at)huawei(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: "miroslav(dot)sulc(at)fordfrog(dot)com" <miroslav(dot)sulc(at)fordfrog(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraintdoes not work on inherited master table
Date: 2012-07-17 08:59:50
Message-ID: 6C0B27F7206C9E4CA54AE035729E9C382851E5AB@szxeml509-mbs (view raw or flat)
Thread:
Lists: pgsql-bugs
> From: Noah Misch [noah(at)leadboat(dot)com]
> Sent: Monday, July 16, 2012 8:42 PM
> On Mon, Jul 16, 2012 at 04:49:46PM +0530, Amit Kapila wrote:

>> > Care to prepare a patch with a test case addition?
>>  Let me know if above is sufficient or shall I include anything more in
>> patch.

> I can't think of anything else.

Patch is attached with this mail.

> As a side question for the list, should we fix this differently in 9.2 to
> avoid forcing an initdb for the next beta?  Perhaps have
> ATExecDropConstraint() only respect connoinherit for CONSTRAINT_CHECK?

Let me know if anything needs to be done for this?

With Regards,
Amit Kapila.

Attachment: defect_fix_6712.patch
Description: text/plain (8.7 KB)

In response to

Responses

pgsql-bugs by date

Next:From: Simon RiggsDate: 2012-07-17 09:25:04
Subject: Re: BUG #6736: Hot-standby replica crashed after failover:
Previous:From: Dave PageDate: 2012-07-17 07:16:30
Subject: Re: Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group