Re: tablespace and sequences?

Philip Warner wrote:
> At 12:21 AM 20/08/2004, Tom Lane wrote:
> >You can give it a new paint job in 8.1, if you like.
> 
> To side-step the issue, is there a tablespace equivalent of a default schema?
> 
> Could we 'set default tablespace xxx', then have pg_dump/restore use a 
> 'create table' that does not refer to the tablespace?

That is what I was assuming.  You can't retroactively change the dump
file during restore so we would have some SET varaiable you would set
before doing the restore that said to handle create tablespace errors.

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