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 DB4EE4759B2; Sat, 13 Jul 2002 10:51:00 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g6DEoxE23984; Sat, 13 Jul 2002 10:50:59 -0400 (EDT) From: Bruce Momjian Message-Id: <200207131450.g6DEoxE23984@candle.pha.pa.us> Subject: Re: pg_restore cannot restore index In-Reply-To: <7C760DAA511DC74B99E7D22189F786F101BF2119@MAIL01.stbernard.com> To: Jie Liang Date: Sat, 13 Jul 2002 10:50:59 -0400 (EDT) Cc: "'Jan Wieck'" , "'admin@postgresql.org'" , "'pgsql-sql@postgresql.org'" X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary=ELM1026571859-18181-1_ Content-Transfer-Encoding: 7bit X-Archive-Number: 200207/201 X-Sequence-Number: 8580 --ELM1026571859-18181-1_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII 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 --ELM1026571859-18181-1_ Content-Transfer-Encoding: 7bit Content-Type: text/plain Content-Disposition: inline; filename="/bjm/diff" *** ./pg_restore.c.orig Sat Jul 13 10:45:43 2002 --- ./pg_restore.c Sat Jul 13 10:45:55 2002 *************** *** 163,171 **** } #ifdef HAVE_GETOPT_LONG ! while ((c = getopt_long(argc, argv, "acCd:f:F:h:i:lL:NoOp:P:rRsS:t:T:uU:vWxX:", cmdopts, NULL)) != -1) #else ! while ((c = getopt(argc, argv, "acCd:f:F:h:i:lL:NoOp:P:rRsS:t:T:uU:vWxX:")) != -1) #endif { switch (c) --- 163,171 ---- } #ifdef HAVE_GETOPT_LONG ! while ((c = getopt_long(argc, argv, "acCd:f:F:h:iI:lL:NoOp:P:rRsS:t:T:uU:vWxX:", cmdopts, NULL)) != -1) #else ! while ((c = getopt(argc, argv, "acCd:f:F:h:iI:lL:NoOp:P:rRsS:t:T:uU:vWxX:")) != -1) #endif { switch (c) --ELM1026571859-18181-1_--