Re: Using ALTER TABLESPACE in pg_dump

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> At 03:06 AM 20/10/2004, Tom Lane wrote:
>> I think the tricky part of that would be inserting the tablespace clause
>> in the right place; for CREATE INDEX this seems to require nontrivial
>> parsing. (Both the index column definitions and the WHERE clause could
>> be arbitrarily complicated expressions.) If we can get around that part
>> then this wouldn't be too hard.

> I may be missing something here; I was assuming that pg_dump would dump
> would build the CREATE INDEX/TABLE/etc commands with the %%tablespace%%
> already embedded. pg_restore would not need to do any parsing. Or is there
> something I don't understand?

Maybe there's something I don't understand. How are you expecting
pg_restore to control whether it outputs the command with a TABLESPACE
clause embedded or not, if pg_dump has already built the command string
that way? I thought you were envisioning that pg_restore would insert,
or not insert, a TABLESPACE clause into a command that didn't initially
have one.

regards, tom lane