Robert Haas wrote:
On Wed, Aug 4, 2010 at 6:41 AM, Yeb Havinga <yebhavi...@gmail.com> wrote:
If child inherits column A from parent1 and parent2, and it is then
renamed to B in parent2, what should the name be in the child after
the rename is completed?
The column should be renamed to B in parent2, child and parent1.
Uh, really? Wow. You want to follow the inheritance hierarchy in
both directions, both down and up? That seems like it could be
confusing.
Yes, the idea is to follow the up direction in the case of column
changes, only if the column is already present in another parent. To
avoid confusion we could block the first attempt of a change with a
message other parents exists, and the hint to add e.g. CASCADE to update
the definition in the other parent as well.
-- Yeb
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
