The following bug has been logged on the website:
Bug reference: 7583
Logged by: Bryan Love
Email address: [email protected]
PostgreSQL version: 9.2.1
Operating system: Centos 6
Description:
After creating a table using LIKE and INHERITS, if you drop a column from
the parent table that existed prior to creation of the child table, the
column will not be dropped from the child table.
Test Case:
=# create table foo(col1 int, col2 int);
=# create table bar (like foo) inherits (foo);
NOTICE: merging column "col1" with inherited definition
NOTICE: merging column "col2" with inherited definition
CREATE TABLE
=# alter table foo drop col1;
ALTER TABLE
=# \d bar
Table "public.bar"
Column | Type | Modifiers
--------+---------+-----------
col1 | integer |
col2 | integer |
Inherits: foo
--- copy/paste block commands ----
drop table bar;
drop table foo;
create table foo(col1 int, col2 int);
create table bar (like foo) inherits (foo);
alter table foo drop col1;
\d bar
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
