Re: open item: tablespace handing in pg_dump/pg_restore

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: open item: tablespace handing in pg_dump/pg_restore
Date: 2004-09-02 00:30:29
Message-ID: 200409020030.i820UTv18610@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-hackers pgsql-hackers-win32

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Reini Urban 2004-09-02 06:44:28 Re: time_t timezone
Previous Message Bruce Momjian 2004-09-01 21:45:21 Re: time_t timezone

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-02 00:51:06 Re: iinvalid string enlargement PG 7.4.5
Previous Message Bruce Momjian 2004-09-01 23:29:18 Re: plperl regression tests

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Tony and Bryn Reina 2004-09-02 05:44:23 Re: Compiling beta2 with openssl on XP Pro
Previous Message Tom Lane 2004-09-01 22:29:58 Re: Compiling beta2 with openssl on XP Pro