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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
