Marc G. Fournier wrote: > On Mon, 8 Nov 2004, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > >> > >> Just curious, but in what sort of circumstance could this happen? > >> Permissions problems, that sort of thing? > > > > Restoring a dump to another system that doesn't have the same > > directories to create the tablespaces. > > 'k, that's what I thought, just wanted to clarify ... stupid question then > ... if such a case happens, do we send a WARNING to let ppl know that the > load didn't quite go as the dump went?
Yes, they get a warning because the tablespace create failed. When we had a TABLESPACE clause in create (before default_tablespace), all the CREATEs would fail leading to a useless restore. -- 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 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match