restore bug of pgadminIII 1.20.0

From: YuanyuanLiu <liuyuanyuangogo(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: restore bug of pgadminIII 1.20.0
Date: 2015-12-30 08:14:10
Message-ID: 1451463249999-5879508.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2015-12-30 11:03:49 Re: restore bug of pgadminIII 1.20.0
Previous Message Christoph Berg 2015-12-29 18:01:59 Re: Bug#808924: pgadmin3 uses deprecated find -perm +xxx syntax, please switch to find -perm /+++