From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "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:25:09 |
Message-ID: | 41294775.1050407@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
>>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...
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-08-23 01:30:35 | Re: Call for objections: removing contrib/rserv for 8.0 |
Previous Message | Christopher Kings-Lynne | 2004-08-23 01:20:59 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-08-23 01:34:03 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
Previous Message | Christopher Kings-Lynne | 2004-08-23 01:20:59 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |