Re: Using ALTER TABLESPACE in pg_dump

OK, TODO updated:
* Add a GUC variable to control the tablespace for temporary  objects

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Gavin Sherry wrote:
> >> I'm not sure about TOAST however. I considered the idea of adding
> >> something to CREATE TABLE like TOASTSPACE <tablespace>, such that all
> >> TOAST tables would be put in the 'toastspace'. But I think the syntax is
> >> ugly and would confuse many users who do not know what toast is.
> 
> > I think we need to add temp_tablespace and toast_tablespace GUC
> > variables to deal with this, perhaps for 8.1.
> 
> A tablespace for temp tables is okay, but I'm fairly dubious about the
> idea of a "toast tablespace".  The current behavior is that a toast
> table is automatically placed into the same tablespace as its parent,
> and that seems exactly right to me.  It's certainly the right thing from
> the point of view of users who do not understand TOAST and expect all of
> a table's data to get put where they said to put the table.
> 
>             regards, tom lane
> 

--  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