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 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers