BUG #4291: Inheritance fails on column suppression

Поиск
Список
Период
Сортировка
От Duprez
Тема BUG #4291: Inheritance fails on column suppression
Дата
Msg-id 200807100708.m6A78Q57015269@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4291: Inheritance fails on column suppression
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4291
Logged by:          Duprez
Email address:      c.duprez@libertysurf.fr
PostgreSQL version: 8.3.3
Operating system:   Windows XP
Description:        Inheritance fails on column suppression
Details:

Hello,

I use Postgresql on Windows XP 8.3.3.
I have created 2 schema, and the tables of the second one inherits the
tables of the first one :

CREATE schema test1;
CREATE schema test2;

CREATE TABLE test1.point (code char(16), test1 char(2), test2 char(3));
CREATE TABLE test2.point (code2 char(16)) INHERITS (test1.point);

Then, I remove th inheritance link by performing an ALTER command :

ALTER TABLE test2.point NO INHERIT test1.point;

And then, I restablish the inheritance :

ALTER TABLE test2.point INHERIT test1.point;

The problem is that, if now I drop a column from the parent table, the
column remains in the child table, whereas the inheritance is established :

ALTER TABLE test1.point DROP COLUMN test2 CASCADE;

The column "test2" remains in "test2.point" table.
According to the documentation, this should not be the case.

Regards,
C. Duprez

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4290: wrong double subselect with aggregate function
Следующее
От: "Lampa"
Дата:
Сообщение: BUG #4292: directory pg_clog never cleaned