Re: [HACKERS] pg_dump ignore tablespaces

2007-07-14 Thread Tom Lane
"Gavin M. Roy" <[EMAIL PROTECTED]> writes: > Recently I ran into an issue where restoring from pg_dump from one machine > to another with non-matching tablespaces. The primary issue is that index > creation will fail if the tablespace does not exist from the dump. I was > thinking to best solutio

[HACKERS] pg_dump ignore tablespaces

2007-07-14 Thread Gavin M. Roy
Recently I ran into an issue where restoring from pg_dump from one machine to another with non-matching tablespaces. The primary issue is that index creation will fail if the tablespace does not exist from the dump. I was thinking to best solution for this would be a pg_dump option such as --ign