From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Rob Richardson <interrobang(at)yahoo(dot)com> |
Cc: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Navigation through edit screen is very difficult |
Date: | 2018-08-09 15:30:57 |
Message-ID: | CA+OCxow630z9G=hTC5UCam6e6wdoeVMeoLor3Qi2VAox1abibw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Thu, Aug 9, 2018 at 3:49 PM, Rob Richardson <interrobang(at)yahoo(dot)com>
wrote:
> Thank you, but that did not work. I am running pgAdmin 4 on a Windows 7
> box, executing the file pgAdmin4.exe in my c:/Program Files
> (x86)/pgAmin4/v3/runtime folder. Should config_local.py be a copy of
> config.py except for the record count value, or should config_local.py just
> contain the one line?
>
It only needs to contain one line. Copying config.py isn't a good idea as
it's contents will change when you next upgrade.
>
> On Thursday, August 9, 2018, 10:27:21 AM EDT, Dave Page <dpage(at)pgadmin(dot)org>
> wrote:
>
>
>
>
> On Thu, Aug 9, 2018 at 3:10 PM, Rob Richardson <interrobang(at)yahoo(dot)com>
> wrote:
>
> In pgAdmin 3, if I select a table with a few thousand rows and then click
> the Edit button, I get a grid of data and a vertical scrollbar. If I drag
> the scrollbar's thumb to the bottom of the bar, I am taken to the bottom of
> my result set and the blank row where I can add a new row if I want to.
> But in pgAdmin 4, the scrollbar's parameters are only calculated on the
> basis of some subset of the rows in the table. So, I drag the thumb to the
> bottom of the scrollbar, the selected row goes to some random row part way
> down the grid, the scroll bar's parameters are recalculated, and the thumb
> jumps up to somewhere around a third of the way up from the bottom. If I
> drag the thumb down again, the process repeats. I don't know how many
> times I have to do that to get to the bottom of the grid and the blank row,
> since I've never had that much patience. The only way I can get to the
> bottom is to select some random cell and then hold down the Page Down key
> until I get there.
>
> Is there some way I can get the scrollbar to behave the same way it does
> in pgAdmin 3?
>
>
> Create (or edit if it exists) a file called config_local.py in the same
> directory as config.py (normally $INSTALLDIR/web). Add the following line
> to it:
>
> ON_DEMAND_RECORD_COUNT = 10000000
>
> Restart pgAdmin.
>
> That will adjust the number of records retrieved at any one time to 10
> million, effectively disabling on demand loading for tables with < 10M
> rows. Of course, you can adjust that number to something lower (or higher)
> if you prefer. The default is 1000.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Calle Hedberg | 2018-08-09 15:43:51 | Re: Navigation through edit screen is very difficult |
Previous Message | Rob Richardson | 2018-08-09 15:04:49 | Re: Navigation through edit screen is very difficult |