The following bug has been logged on the website:
Bug reference: 7583
Logged by: Bryan Love
Email address: bryan.love@iovation.com
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:
=3D# create table foo(col1 int, col2 int);
=3D# create table bar (like foo) inherits (foo);
NOTICE: merging column "col1" with inherited definition
NOTICE: merging column "col2" with inherited definition
CREATE TABLE
=3D# alter table foo drop col1;
ALTER TABLE
=3D# \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
