Hi, Please find the attached patch file with the fix. - Reformatted the input string for the "pg_restore" command line options.
Let me know for any comments. Thanks, Neel Patel On Wed, Dec 30, 2015 at 4:37 PM, Neel Patel <neel.pa...@enterprisedb.com> wrote: > Hi Dave, > > Sure. I will look into this issue and share the analysis/fix. > > Thanks, > Neel Patel > > On Wed, Dec 30, 2015 at 4:33 PM, Dave Page <dp...@pgadmin.org> wrote: > >> 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 <liuyuanyuang...@gmail.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 <http://nabble.com>. >> >> >> -- >> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgadmin-support >> >> >
pgAdmin_restore.patch
Description: Binary data
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
