From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: bug in DROP TABLESPACE |
Date: | 2004-07-11 02:02:54 |
Message-ID: | 200407110202.i6B22sQ10812@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Added to TODO:
* Allow changing of already-created database and schema
tablespaces
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
> > Tom already mentioned this just after committing tablespaces: 'Minor DROP
> > TABLESPACE issue'
> >
> > http://www.mail-archive.com/pgsql-hackers(at)postgresql(dot)org/msg46540.html
> >
> > In fact, I see that you contributed to the thread :-).
> >
> > I think the result of the thread was to make the error message a little
> > more helpful and that adding empty files to represent schemas would be a
> > pain (think WAL and name collision).
>
> Ah, I must have been in a dream state.
>
> The other thing we need are these two commands:
>
> ALTER DATABASE foo SET TABLESPACE spc;
> ALTER SCHEMA foo SET TABLESPACE spc;
>
> I think these should not be considered new features but essential
> functionality left out of the original patch.
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-07-11 02:11:46 | Re: Status report |
Previous Message | Christopher Kings-Lynne | 2004-07-11 01:45:29 | Re: Status report |