On 03/03/10 15:46, Greg Sabino Mullane wrote:
> ALTER TABLE will lock and block, but I'd be remiss if I didn't point
> out the use of session_replication_role as a much better solution to
> this particular class of problem. (Even if your version does not
> support it, Vick, it should be noted here for the archives). The
> session_replication_role was added in 8.3:
>
> http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html
That wouldn't have occurred to me. Definitely worth adding to the archives.
--
Richard Huxton
Archonet Ltd