From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, 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 03:16:59 |
Message-ID: | 200408222316.59137.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Sunday 22 August 2004 21:34, Marc G. Fournier wrote:
> 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 ...
>
A dump/reload can fix a lot of problems... of course the people who are most
likely to use tablespaces are probably the same people most likely to not be
able to do a dump/reload just after doing the dump/reload they had to do to
upgrade to 8.0. Hopefully they'll have more forsight than we did...
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-08-23 03:17:45 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
Previous Message | Christopher Kings-Lynne | 2004-08-23 03:11:29 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-08-23 03:17:45 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |
Previous Message | Christopher Kings-Lynne | 2004-08-23 03:11:29 | Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE |