Tom Lane wrote: > Stephen Frost <sfr...@snowman.net> writes: > > That it's more-or-less a bulk 'ALTER TABLE' operation is why I had been > > trying to think of a way to put it under that command. What if we had a > > more general way to reference 'all objects in a tablespace'? > > "tablespace.*" or "ALL:TABLESAPCE"? Are there other places which might > > benefit from being able to take and operate on all objects in a > > tablespace? > > > Of course, we handle this in 'GRANT' with 'GRANT ON ALL TABLES', so why > > not 'ALTER TABLE ON ALL TABLES IN TABLESPACE <blah>'? that does get > > pretty darn verbose but is at least a bit more in-line with what we have > > done before.. > > That's not a bad line of thought --- I doubt that verbosity is critical > here.
Yep, that works for my purposes. Also, it seems there should be no parse conflict because ON is already a reserved keyword .. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers