BUG #7583: Problem using INHERITS and LIKE

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