Re: bug in DROP TABLESPACE - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: bug in DROP TABLESPACE
Date
Msg-id 200407110202.i6B22sQ10812@candle.pha.pa.us
Whole thread Raw
In response to Re: bug in DROP TABLESPACE  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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@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
 


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Status report
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Status report