| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLESPACE ... MOVE ALL TO ... |
| Date: | 2014-01-20 09:57:43 |
| Message-ID: | CA+U5nM+_WA64pyDT-FYc3DQvWuWewn3=Bgv10E5rMf+2srnyCQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 16 January 2014 22:37, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> allow users to more easily move their various objects from
> one tablespace to another. Included are docs and a regression test;
> I'm happy to improve on both should folks send me suggestions.
Sounds good.
The command uses the word ALL but then less than all objects, i.e.
only moves objects that are owned by the user.
I would like to see two variants of this...
ALL ... which attempts to move all objects and fails if it doesn't own
everything
ALL OWNED ... which moves only objects that it owns, and ignores others
i.e. ALL should mean all
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mel Gorman | 2014-01-20 10:23:18 | Re: [Lsf-pc] Re: Linux kernel impact on PostgreSQL performance (summary v2 2014-1-17) |
| Previous Message | Sameer Kumar | 2014-01-20 09:50:02 | Re: using rpmbuild with PostgreSQL 9.2.6 source code |