> It is a little bit different because a schema, a table or a function are
> database application issues and are normally addressed by pg_dump and
> pg_restore, although tablespaces are more an administration issue wrt disk
> layout and the like, which are likely to be different from one machine to
> another (compare with I obviously want the same schema/table/function for
> my application). So the notion of dump/restore of a tablespace need
> some careful thinking.
>
> But maybe I'm just stupid to dream that I could restore or transfer my
> data even if I used a tablespace somewhere? ;-)
OK, perhaps. It it not easy to implement however, since the tablespace
clause on indexes comes from the pg_get_indexdef() function and isn't
added by pg_dump.
Bruce - pg_dump TODO for --no-tablespace or something?
Chris