Re: Not null constraint violation flagged on a field that has a value

2018-08-09 Thread Rob Richardson
Please ignore my previous message on this topic.  The error was being raised by a trigger. My apologies for cluttering the list. RobR On Thursday, August 9, 2018, 3:07:03 PM EDT, Rob Richardson wrote: Please see the attached image.  As you can see, a not-null constraint error is being

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Dave Page
Hi On Thu, Aug 9, 2018 at 4:43 PM, Calle Hedberg wrote: > Hi > > Clicking top-left corner (aka "Select All") does work on my Win10-64 > laptop, at least for tables with a few 10-thousands rows. > Yes, that should also work (and there's a regression test to prove it!). It has to load them all if

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Calle Hedberg
Hi Clicking top-left corner (aka "Select All") does work on my Win10-64 laptop, at least for tables with a few 10-thousands rows. Haven't tried with e.g. 5 or 10 million (I suspect that might take considerable time, so I'm not sure if Dave's suggestion to increase the ON_DEMAND_RECORD_COUNT is ide

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Dave Page
On Thu, Aug 9, 2018 at 3:49 PM, Rob Richardson 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

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Rob Richardson
I edited config.py, and that worked. RobR On Thursday, August 9, 2018, 10:49:29 AM EDT, Rob Richardson 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

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Rob Richardson
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

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Mark Watson
From: Rob Richardson Sent: Thursday, August 9, 2018 10:10 AM To: pgadmin-support@lists.postgresql.org Subject: Navigation through edit screen is very difficult 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 scrollba

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Dave Page
On Thu, Aug 9, 2018 at 3:10 PM, Rob Richardson 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

Re: Navigation through edit screen is very difficult

2018-08-09 Thread Dave Caughey
Agreed! On Thu, Aug 9, 2018 at 10:10 AM Rob Richardson 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 > m

Navigation through edit screen is very difficult

2018-08-09 Thread Rob Richardson
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.

pgAdmin 4 v3.2 released

2018-08-09 Thread Akshay Joshi
The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.2. This release of pgAdmin 4 includes over 20 bug fixes and new features. For more details please see the release notes at: https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_3_2.html. pgAdmin is the leading Open So