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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
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-28 22:29:39
Message-ID: 200408282229.i7SMTdI20993@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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...

This is going to have to wait for 8.1.  If it was so important, someone
would have asked for it long before we went beta.  It is now on the TODO
list.

Also, I question the value of being able to change the default but not
being able to move the schema contents.  In fact, I can't think of any
other case where we change the default for new objects but leave the old
objects with their original settings.  This all needs discussion for
8.1.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-08-28 22:52:59
Subject: Re: compile warnings in HEAD
Previous:From: Josh BerkusDate: 2004-08-28 20:01:02
Subject: Re: Contrib -- PostgreSQL shared variables

pgsql-patches by date

Next:From: Joe ConwayDate: 2004-08-28 22:41:27
Subject: Re: [SQL] array_in: '{}}'::text[]
Previous:From: Bruce MomjianDate: 2004-08-28 21:01:43
Subject: Re: Service startup delay

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