On 2017/05/10 6:51, Thomas Munro wrote: > No such problem exists for partition hierarchies since the tables all > appear as the same type to user code (though conversions may be > happening for technical reasons).
To clarify a bit, there may exist differences in the ordering of columns, either between the parent and its partitions or between different partitions. For example, while parent's rowtype is (a int, b char, c float), a partition's may be (b char, a int, c float), and yet another partition may have (c float, a int, b char). If some user code happens to depend on the ordering of columns, selecting from the parent and selecting from a partition directly may return the same result but in different formats. Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers