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

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

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073