Re: restore bug of pgadminIII 1.20.0

From: Dave Page <dpage(at)pgadmin(dot)org>
To: YuanyuanLiu <liuyuanyuangogo(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org, Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>
Subject: Re: restore bug of pgadminIII 1.20.0
Date: 2015-12-30 11:03:49
Message-ID: 7F4A3665-310D-4E4E-89CE-682B5195D81A@pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Neel, can you look at this please?

Thanks.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company

> On 30 Dec 2015, at 08:14, YuanyuanLiu <liuyuanyuangogo(at)gmail(dot)com> wrote:
>
> Hi, I found a bug of restore of pgadminIII v1.20.0 , which I installed by
> postgresql-9.4 Graphical installer for windows 32bit).
>
> This is my test example: I tried use pgadminIII to restore table A1 in
> schema publicA in database Vvv1.
> then it failed and I got the message:
> D:\Program Files (x86)\PostgreSQL\9.4\bin>pg_restore.exe --host localhost
> --port
> 5433 --username "postgres" --dbname "Vvv1" --no-password --data-only
> --table \"A1\" --schem
> a \"publicA\" --verbose "C:\Users\Yuanyuan\Desktop\1"
> ....
>
> I found the table and schema name format is wrong, the right way is like the
> follwing. and success to restore my table by execute commands like the
> following:
> D:\Program Files (x86)\PostgreSQL\9.4\bin>pg_restore.exe --host localhost
> --port
> 5433 --username "postgres" --dbname "Vvv1" --no-password --data-only
> --table "A1" --schema
> "publicA" --verbose "C:\Users\Yuanyuan\Desktop\1"
>
> I don't know whether anyone has fixed this problem, so I write this to you!
> please have a look!
> Thanks and regards!
>
> Holiday Liu
>
>
>
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/restore-bug-of-pgadminIII-1-20-0-tp5879508.html
> Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Neel Patel 2015-12-30 11:07:55 Re: restore bug of pgadminIII 1.20.0
Previous Message YuanyuanLiu 2015-12-30 08:14:10 restore bug of pgadminIII 1.20.0