John R Pierce wrote:
> otoh, reordering the fields in a table would likely require a global
> exclusive access lock on the table for the duration of the
> operation, which for a large table could be substantial.
Obviously you haven't read the previous proposal on how to handle it.
It doesn't require rewriting the whole table.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support