Re: Reporting bug on pgAdmin 4.3

Hi, since I'm not with the test environment so there may be not very exact answers.

1, The data was set to load from oracle server at 0 am of each work day. There are 3 ways to determine the right results:
a. data from oracle server;
b. there is going to be a statement summary in query history;
c. use select count() statement

2, Yes they do all have data, but I do not have time to test them since I was at work. Furthermore, each time there will be differences in number of rows.

3, I click the top left cell in data output window, so it will select all the data. Paste them to excel.

4, Yep, client means psql.

5, Yes I installed pgadmin 4.3 on the server too. While executing the same statement on the server using remote desktop (windows), it shows the correct results.

6, I may do some more tests when I have time.

7, Anymore questions, please let me know

Thanks a lot!

Shore

------------------ Original ------------------
From: "Adrian Klaver"<adrian(dot)klaver(at)aklaver(dot)com>;
Date: Tue, Jul 10, 2018 09:30 PM
To: "a"<372660931(at)qq(dot)com>;"pgsql-general"<pgsql-general(at)postgresql(dot)org>;

Subject: Re: Reporting bug on pgAdmin 4.3

On 07/09/2018 09:40 PM, a wrote:
> Hi
>
> I'm doing a normal query on pgAdmin, my server platform is win server
> 2008, my laptop is win10, both using pgsql 10.
>
> The results of the query shows 8488 rows are selected, which is correct.

How did you determine this, in pgAdmin or somewhere else?

>
> However, when I drag down in data output window, it shows more than
> 100000 rows.

The rows all have data?

>
> Further test shows that each time they are different, both in number and
> in actual data.
>
> The past and copy results are the same, even without drag down actions.

So where did you paste and copy from and how?

>
> ODBC works fine, I haven't try the client.

By client do you mean psql or something else?

>
> This problem only occur on my computer, while trying on the server, it
> works fine.

Do you mean using pgAdmin works on the server.

>
> Can any one provide any method to fix this??

Not enough information at this time to arrive at a fix.

>
> Thanks
>
> Shore

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com