* Tom Lane (t...@sss.pgh.pa.us) 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.
Alright, sounds like this is more-or-less the concensus. I'll see about making it happen shortly. Thanks! Stephen
signature.asc
Description: Digital signature