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

I'd like it applied, but change it to 'SET DEFAULT TABLESPACE' perhaps...?

Chris

Bruce Momjian wrote:
> Would people like this applied to 8.0?  It addresses another of the
> tablespace deficiency.
> 
> 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
> 
>