From: | Neel Patel <neel(dot)patel(at)enterprisedb(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | YuanyuanLiu <liuyuanyuangogo(at)gmail(dot)com>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: restore bug of pgadminIII 1.20.0 |
Date: | 2016-01-06 09:16:47 |
Message-ID: | CACCA4P03Zme0F1ucCVqq+DrxTCc5GpnU63UOUSedpa8PsCsArw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(dot)patel(at)enterprisedb(dot)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 <dpage(at)pgadmin(dot)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 <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 <http://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
>>
>>
>
Attachment | Content-Type | Size |
---|---|---|
pgAdmin_restore.patch | application/octet-stream | 1.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2016-01-06 09:49:16 | Re: restore bug of pgadminIII 1.20.0 |
Previous Message | Dave Page | 2016-01-04 09:24:14 | Re: Re: Bug#808924: pgadmin3 uses deprecated find -perm +xxx syntax, please switch to find -perm /+++ |