Re: tablespace and sequences?

Philip Warner wrote:
> At 02:33 AM 20/08/2004, Bruce Momjian wrote:
> > > 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.
> 
> Actually I was thinking of a little more than a setting to ignore errors; 
> we would need to:
> 
>     - modify pg_dump to store the tablespace name as a separate
>       part of the TOC entry, NOT as part of the CREATE TABLE.
>     - modify pg_restore to issue 'set default tablespace xxxx'
>       before restoring a table OR, per Fabiens suggestion, issue
>       an ALTER TABLE after the create.
> 
> Then table-space related errors will not stop a table being created.

But that doesn't fix ascii dumps loaded via psql.

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