Re: restore bug of pgadminIII 1.20.0

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, YuanyuanLiu <liuyuanyuangogo(at)gmail(dot)com>, pgadmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: restore bug of pgadminIII 1.20.0
Date: 2016-02-02 15:55:26
Message-ID: CAG7mmowmkRODUZXS7W9hHUxshLJr2oMFJJBExOjj319vsbg2Rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Neel,

On Wed, Jan 6, 2016 at 2:46 PM, Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>
wrote:

> Hi,
>
> Please find the attached patch file with the fix.
> - Reformatted the input string for the "pg_restore" command line options.
>
We're using 'commandLineCleanOption' a quite a lot place with second
argument as true.

Do you think - they do work well there?
i.e.
frmBackup class
In the same function for function object.

Eyeball review suggests - it should not.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com/>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

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
>>>
>>>
>>
>
>
> --
> 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

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2016-02-03 09:45:15 Re: bug report: pgadmin3 server status dialog malfunction
Previous Message Dave Page 2016-02-02 11:18:45 Re: bug report: pgadmin3 server status dialog malfunction