Re: bug in DROP TABLESPACE

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