BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table

Поиск
Список
Период
Сортировка
От miroslav.sulc@fordfrog.com
Тема BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table
Дата
Msg-id E1SkvNT-00066C-C4@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table  (Amit Kapila <amit.kapila@huawei.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6712
Logged by:          Miroslav =C5=A0ulc
Email address:      miroslav.sulc@fordfrog.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Gentoo Linux
Description:=20=20=20=20=20=20=20=20

here is the test case:

test=3D# create table test_constraints (id int, val1 varchar, val2 int, uni=
que
(val1, val2));
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"test_constraints_val1_val2_key" for table "test_constraints"
CREATE TABLE
test=3D# create table test_constraints_inh () inherits (test_constraints);
CREATE TABLE
test=3D# alter table only test_constraints drop constraint
test_constraints_val1_val2_key;
ERROR:  constraint "test_constraints_val1_val2_key" of relation
"test_constraints_inh" does not exist


postgresql tries to drop the constraint even from descendant table though
"only" is specified.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created