From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
Date: | 2004-08-20 20:00:24 |
Message-ID: | 20040820165943.V30511@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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(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
>
> ---------------------------(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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-08-20 20:00:29 | pg_dump print error location |
Previous Message | Alvaro Herrera | 2004-08-20 19:56:46 | Re: pg_subtrans and WAL |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-08-20 20:00:29 | pg_dump print error location |
Previous Message | Bruce Momjian | 2004-08-20 19:47:54 | Re: compile fix for contrib/fuzzystrmatch |