| From: | Keith Fiske <keith(at)omniti(dot)com> |
|---|---|
| To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Dropping columns with inheritance not working as documented |
| Date: | 2015-06-02 21:52:05 |
| Message-ID: | CAG1_KcAmEYNRxbU5vJL3pWkXAsmtgZONZpf7F7ikXscd--TRvg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
While investigating an issue someone reported in pg_partman (
https://github.com/keithf4/pg_partman/issues/61) came across something that
seems very inconsistent with Inheritance.
According to the documentation, dropping a column should be propagated down
to all children. This only seems to happen for columns that are added AFTER
a child table is inherited. There's no way to tell when a column was added
to an inheritance set, so this could be very confusing for someone down the
line that wasn't there when a table was set up.
Here is a gist showing this using the current version of pg_partman (1.8.6)
on PostgreSQL 9.4.2
https://gist.github.com/keithf4/a762144e46d0c4211d25
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-06-02 22:18:10 | Re: Dropping columns with inheritance not working as documented |
| Previous Message | Gavin Flower | 2015-06-02 19:19:23 | Re: postgres documentation - proposed improvement/clarification |