| From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, 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:34:03 |
| Message-ID: | 20040822223348.Y10415@ganymede.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Mon, 23 Aug 2004, Christopher Kings-Lynne wrote:
>>> 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 ...
>>
>>
>> I am inclined to agree. ALTER INDEX is an operation that will happen
>> quite often, but I don't think ALTER SCHEMA will be as frequent, and the
>> given solution doesn't address the two needs of moving the entire schema
>> or just future object creation.
>
> No, it implements something that is currently impossible without editing the
> system catalogs - clearly an oversight! Especially if we add a disk-based
> change to it to avoid those drop tablespace errors.
>
> It will be 5 minutes before someone who has created a schema in 8.0 and then
> will want to make it have a different default - there's no way they can do
> it...
If they just created the schema, then a dump/reload would fix it ...
----
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 | Christopher Kings-Lynne | 2004-08-23 02:32:44 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
| Previous Message | Christopher Kings-Lynne | 2004-08-23 01:30:35 | Re: Call for objections: removing contrib/rserv for 8.0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-08-23 01:43:02 | Re: SGML cleanup |
| Previous Message | Christopher Kings-Lynne | 2004-08-23 01:25:09 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |