Re: Using ALTER TABLESPACE in pg_dump

Gavin Sherry wrote:
> > One downside that came up yesterday in a discussion is that once shemas
> > don't have default tablespaces we can't easily have default tablespaces
> > for toast and temporary table system schemas.  Now we can't actually do
> > that now anyway because they are created by the system but it might
> > limit how we can control these in the future.  I am just throwing this
> > out as a point.
> 
> Neil has been talking to me about being able to set a tablespace for
> temporary tables at or after create database time.
> 
> 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.

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