On 27.2.2015 19:23, Alvaro Herrera wrote:
> Tomas Vondra wrote:
>
>> Physical ordering is still determined by the CREATE TABLE command,
>
> In theory, you should be able to UPDATE attphysnum in pg_attribute
> too when the table is empty, and new tuples inserted would follow
> the specified ordering.
Good idea - that'd give you descriptors with
(attnum != attphysnum)
which might trigger some bugs.
--
Tomas Vondra http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services