Re: R: Field's position in Table - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: R: Field's position in Table
Date
Msg-id 20090824203957.GK5962@alvh.no-ip.org
Whole thread Raw
In response to Re: R: Field's position in Table  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Sergey Samokhin
Date:
Subject: Re: How to simulate crashes of PostgreSQL?
Next
From: "Bayless Kirtley"
Date:
Subject: Re: R: Field's position in Table