| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLESPACE MOVE command tag tweak |
| Date: | 2014-06-24 01:25:26 |
| Message-ID: | 20508.1403573126@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Stephen Frost <sfrost(at)snowman(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2014-06-24 01:25:48 | tab completion for setting search_path |
| Previous Message | Jeff Janes | 2014-06-24 01:20:32 | Supporting Windows SChannel as OpenSSL replacement |