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@postgresql.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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073