Re: [HACKERS] ALTER TABLE ONLY ...DROP CONSTRAINT is broken in HEAD.

2011-10-24 Thread Robert Haas
On Mon, Sep 12, 2011 at 11:53 AM, Alexey Klyukin wrote: > This works in 9.1, but not in HEAD: > > CREATE TABLE parent(id INTEGER, CONSTRAINT id_check CHECK(id>1)); > CREATE TABLE child() INHERITS(parent); > > ALTER TABLE ONLY parent DROP CONSTRAINT id_check; > > I'm getting: > ERROR:  relation 164

[HACKERS] ALTER TABLE ONLY ...DROP CONSTRAINT is broken in HEAD.

2011-09-12 Thread Alexey Klyukin
This works in 9.1, but not in HEAD: CREATE TABLE parent(id INTEGER, CONSTRAINT id_check CHECK(id>1)); CREATE TABLE child() INHERITS(parent); ALTER TABLE ONLY parent DROP CONSTRAINT id_check; I'm getting: ERROR: relation 16456 has non-inherited constraint "id_check" where 16456 is the oid of th