From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
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-23 01:20:59 |
Message-ID: | 4129467B.5010406@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-08-23 01:25:09 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
Previous Message | Shachar Shemesh | 2004-08-22 23:49:04 | Re: NLS support for postgreSQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-08-23 01:25:09 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
Previous Message | Alvaro Herrera | 2004-08-23 01:09:32 | Re: SGML cleanup |