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      
PostgreSQL Development, 24x7 Support, Training & Services

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to