Re: tablespace and sequences?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: tablespace and sequences?
Date: 2004-08-18 08:24:37
Message-ID: Pine.LNX.4.58.0408181012110.30419@sablons.cri.ensmp.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-hackers pgsql-hackers-win32


> > I'm not thinking about pg_dumpall but pg_dump/pg_restore.
>
> Tablespaces are dumped by pg_dumpall, not pg_dump.

If so, indeed it would be a non-issue. However,

shell> pg_dump coelho | grep TABLESPACE
CREATE SCHEMA test AUTHORIZATION coelho TABLESPACE test;

"TABLESPACE" appears in a basic pg_dump SQL output. If the test tablespace
does not exist, the command will fail, and so my whole restoration.

Thus I still stick to my opinion;-)

Have a nice day,

--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-08-18 08:39:40 Re: tablespace and sequences?
Previous Message Christopher Kings-Lynne 2004-08-18 07:45:41 Re: tablespace and sequences?

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-08-18 08:39:40 Re: tablespace and sequences?
Previous Message Alvaro Herrera 2004-08-18 07:49:59 Re: [HACKERS] SRPM for 8.0.0 beta?

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Eric Rosenquist 2004-08-18 08:37:31 Re: psql reading from stdin
Previous Message Christopher Kings-Lynne 2004-08-18 07:45:41 Re: tablespace and sequences?