The following bug has been logged on the website: Bug reference: 7583 Logged by: Bryan Love Email address: bryan.l...@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: =# 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 (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs