From: | "Duprez" <c(dot)duprez(at)libertysurf(dot)fr> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4291: Inheritance fails on column suppression |
Date: | 2008-07-10 07:08:26 |
Message-ID: | 200807100708.m6A78Q57015269@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4291
Logged by: Duprez
Email address: c(dot)duprez(at)libertysurf(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Lampa | 2008-07-10 07:17:51 | BUG #4292: directory pg_clog never cleaned |
Previous Message | Tom Lane | 2008-07-09 18:52:04 | Re: BUG #4290: wrong double subselect with aggregate function |