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 по дате отправления: