Re: patch : Allow toast tables to be moved to a different tablespace

2011/11/15 Jaime Casanova <jaime(at)2ndquadrant(dot)com>:
> On Fri, Oct 7, 2011 at 10:10 AM, Julien Tachoires <julmon(at)gmail(dot)com> wrote:
>> Hi,
>>
>> Here's a patch to allow TOAST tables to be moved to a different tablespace.
>> This item has been picked up from the TODO list.
>> Main idea is to consider that a TOAST table can have its own tablespace.
>>
>
> Hi,
>
> This patch doesn't apply cleanly to head now... can you send a new
> version against head?

Hi Jaime,

New patch is attached.

>
> about the patch itself. i don't like the fact that now the normal case
> needs to include the word TABLE. IMHO, it should be optional and if
> ommited TABLE should be assumed
>

Maybe I'd missed something, but the normal case is :
ALTER TABLE ... SET TABLESPACE => moves Table + moves associated TOAST Table
ALTER TABLE ... SET TABLE TABLESPACE => moves Table & keeps associated
TOAST Table at its place
ALTER TABLE ... SET TOAST TABLESPACE => keeps Table at its place &
moves associated TOAST Table

Regards,

--
JT