Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

On Fri, 20 Aug 2004, Bruce Momjian wrote:

> Would people like this applied to 8.0?  It addresses another of the
> tablespace deficiency.

This is an extension of tablespaces, and is not required to fix a bug ... 
therefore, it is a feature, and not eligible for inclusion at this point 
in the development cycle ...
 >
> One item of concern is that it moves the default location for new items
> created, and does not move items already created in the tablespace
> itself.  This conflicts with ALTER TABLE/INDEX which moves the actual
> objects.  I am not sure how we should address this.
>
> ---------------------------------------------------------------------------
>
> Gavin Sherry wrote:
>> This patch implements ALTER SCHEMA ... SET TABLESPACE.
>>
>> This changes the default schema tablespace but does not attempted to move
>> objects within the schema to the new tablespace.
>>
>> Docs, regression test and tab-completion included.
>>
>> There were a few places which conflicted with my alter index patch and
>> I've tried to edit the diff where possible to allow for easy applying.
>>
>> Gavin
>
> Content-Description:
>
> [ Attachment, skipping... ]
>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>
> -- 
>  Bruce Momjian                        |  http://candle.pha.pa.us
>  pgman@candle.pha.pa.us               |  (610) 359-1001
>  +  If your life is a hard drive,     |  13 Roberts Road
>  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664