Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2004-08-23 02:32:44
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Previous:From: Christopher Kings-LynneDate: 2004-08-23 01:30:35
Subject: Re: Call for objections: removing contrib/rserv for 8.0

pgsql-patches by date

Next:From: Oliver JowettDate: 2004-08-23 01:43:02
Subject: Re: SGML cleanup
Previous:From: Christopher Kings-LynneDate: 2004-08-23 01:25:09
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group