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