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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
