Fabien COELHO wrote:
>
> Dear hackers,
>
> > I'm happy to do the pg_dump changes, assuming Tom gets the SET stuff sorted
> > out.
>
> ISTM that the tablespace handling or ignoring in pg_dump/pg_restore is
> still an open issue in current CVS head... waiting for a proper
> implementation after the brain-storming on what seemed to be the
> consensus, that is to output a separate
>
> SET DEFAULT TABLESPACE somewhere;
>
> before object creations in the dump/restore command flow.
>
> I've noticed that the item does not seem to appear in Bruce's list, thus
> I'm afraid it might be lost for 8.0 where I think it belongs... hence this
> little reminder.
It isn't on the open items list because it isn't a _must_ fix for 8.0,
though it is still in my mailbox. As I remember it is to allow objects
to be created when the schema doesn't exist, and for creating more
portable pg_dump CREATE statements. If someone wants to fix that, they
have to get it working and get agreement to put it in during beta.
It is on the TODO list (the missing schemas part).
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073