Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table - Mailing list pgsql-bugs

From: Noah Misch [mailto:noah@leadboat.com]
Sent: Thursday, July 19, 2012 5:23 PM
On Tue, Jul 17, 2012 at 08:59:50AM +0000, Amit kapila wrote:
>> Patch is attached with this mail.

> Thanks.  This patch is ready for committer.

>> +-- Test non-inheritable indices [UNIQUE, EXCLUDE] contraints
>> +CREATE TABLE test_constraints (id int, val1 varchar, val2 int,
UNIQUE(val1, val2));
>> +CREATE TABLE test_constraints_inh () INHERITS (test_constraints);
>> +\d+ test_constraints
>> +ALTER TABLE ONLY test_constraints DROP CONSTRAINT
test_constraints_val1_val2_key;
>> +\d+ test_constraints
>> +\d+ test_constraints_inh

> To keep output terse, I would have omitted "\d" commands or retained only
the
> post-DROP "\d+ test_constraints".  Granted, that's subjective.

Thanks for the review of patch.

With Regards,
Amit Kapila.