Re: DDL Damage Assessment

Peter Geoghegan wrote:

> Why is NOWAIT only supported for SET TABLESPACE? I guess it's just a
> particularly bad case. NOWAIT might be the wrong thing for DDL
> generally.

I didn't realize we supported NOWAIT for SET TABLESPACE.  My hunch is
that if we have that, it should really be supported for anything that
does a table rewrite, or perhaps even anything that requires a full
table scan (such as adding a new CHECK constraint).

OTOH it does seem a wart to have NOWAIT in alter table generally.  You
can get the same effect by doing a LOCK TABLE .. NOWAIT and then ALTER
TABLE, right?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services