Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Date
Msg-id 41294775.1050407@familyhealth.com.au
Whole thread Raw
In response to Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
List pgsql-hackers
>>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


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Call for objections: removing contrib/rserv for 8.0