Re: pg_restore cannot restore index - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: pg_restore cannot restore index
Date
Msg-id 200207131450.g6DEoxE23984@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_restore cannot restore index  (Jie Liang <jie@stbernard.com>)
List pgsql-sql
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
*** ./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)

pgsql-sql by date:

Previous
From: "Julian Scarfe"
Date:
Subject: Indexes with LIKE
Next
From: Stephan Szabo
Date:
Subject: Re: Indexes with LIKE