Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net
	[216.55.132.35]) by postgresql.org (Postfix) with ESMTP
	id 38770475BF2; Mon, 15 Jul 2002 18:23:51 -0400 (EDT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.10.1) id g6FMNki11558;
	Mon, 15 Jul 2002 18:23:46 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200207152223.g6FMNki11558@candle.pha.pa.us>
Subject: Re: pg_restore cannot restore index
In-Reply-To: <7C760DAA511DC74B99E7D22189F786F101BF2121@MAIL01.stbernard.com>
To: Jie Liang <jie@stbernard.com>
Date: Mon, 15 Jul 2002 18:23:46 -0400 (EDT)
Cc: "'Jan Wieck'" <JanWieck@Yahoo.com>,
	"'admin@postgresql.org'" <admin@postgresql.org>,
	"'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Archive-Number: 200207/224
X-Sequence-Number: 8602


I just ran some tests in 7.2.1 and 7.3 and both worked fine.  Can I see
the exact error it generates?

---------------------------------------------------------------------------

Jie Liang wrote:
> Same problem, did you test:
> pg_restore --index=aa --dbname=test /bjm/x
> ??????
> I didn't make it work, I may miss someting.
> 
> Thanks!
> 
> 
> Jie Liang
> 
> 
> 
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: Saturday, July 13, 2002 7:51 AM
> To: Jie Liang
> Cc: 'Jan Wieck'; 'admin@postgresql.org'; 'pgsql-sql@postgresql.org'
> Subject: Re: pg_restore cannot restore index
> 
> 
> Jie Liang wrote:
> > On this point, I'd like to ask:
> > 1. where I can download this new version?
> > 2. does
> > pg_restore --index=aa --dbname=test /bjm/x
> > works also???
> 
> OK, the attached patch should allow -I to work in 7.2.X.  This will all
> be fixed in 7.3.
>   
> > Because
> > pg_restore --table=mytable --dbname=mydb mydumpfile
> > doesn't work!
> 
> Is this a different problem?  --table doesn't work either?
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026