Re: Using ALTER TABLESPACE in pg_dump

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I am confused.  I thought Tom's argument was that we shouldn't add an
> overly complex tablespace SET variable just to prevent the non-standard
> TABLESPACE in CREATE, which I can understand.  However, the text above
> seems to indicate we don't need an 'ignore tablespace specification if
> it does not exist' which I think we do need for cases where we want to
> restore on to a system that doesn't use tablespaces or for
> non-super-user restores.

I'm willing to live with a "soft error" type of GUC variable for those
cases.  I don't want a GUC variable that actively changes the default
tablespace; at least not unless you want to abandon the current
mechanisms for default tablespace choices entirely, and go over to
making the GUC variable be the sole arbiter.  (Which would be consistent
with the way we handle selection of which schema to create in, so I'm
not necessarily against it.)  I guess what I'm trying to say is I don't
want a hodgepodge design, because I think it'll be confusing and
unusable.
        regards, tom lane