Re: Data grid: fetching/scrolling data on user demand

2017-10-16 Thread Murtuza Zabuawala
On Tue, Oct 17, 2017 at 2:22 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > How long does it take in your environnment > to fetch the 1000 first records from > > select * from information_schema.columns a,information_schema.columns b > ​I didn't run it because on my environment just c

Re: No commit nor Rollback button

2017-10-16 Thread Murtuza Zabuawala
On Tue, Oct 17, 2017 at 2:03 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hi Murtuza, > > I found those options for switching between autocommit mode and manual > mode. > > What I suggest here is to add one button for commit and one button for > rollback, > they would be green and r

Re: Data grid: fetching/scrolling data on user demand

2017-10-16 Thread legrand legrand
How long does it take in your environnment to fetch the 1000 first records from select * from information_schema.columns a,information_schema.columns b -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: No commit nor Rollback button

2017-10-16 Thread legrand legrand
Hi Murtuza, I found those options for switching between autocommit mode and manual mode. What I suggest here is to add one button for commit and one button for rollback, they would be green and red in manual transaction mode they would be greyed in autocommit mode. A more advanced behavior in

Re: Data grid: fetching/scrolling data on user demand

2017-10-16 Thread Murtuza Zabuawala
On Tue, Oct 17, 2017 at 12:40 AM, legrand legrand < legrand_legr...@hotmail.com> wrote: > maybe this behavior is related to fetching records using a server-side > cursor > ? > > https://wiki.postgresql.org/wiki/Using_psycopg2_with_ > PostgreSQL#Fetch_Records_using_a_Server-Side_Cursor ​No we are

Re: No commit nor Rollback button

2017-10-16 Thread Murtuza Zabuawala
pgAdmin4 also has option in tool menu. [image: Inline image 1] If Auto commit? and Auto rollback? is set to true then basically it is Auto mode And If you prefer manual control over transactions then just uncheck both the options that will be Manual mode. -- Regards, Murtuza Zabuawala Enterprise

Re: No commit nor Rollback button

2017-10-16 Thread Michael Rasmussen
DataGrip has transaction control in the tool menu. It is pretty handy to have that toggle at hand. Yes, I know how to write a manual transaction, but the point of using a GUI tool is to speed things up and make my life as a Data Engineer easier. It is not for forcing me to type extraneous comma

Re: Data grid: fetching/scrolling data on user demand

2017-10-16 Thread legrand legrand
maybe this behavior is related to fetching records using a server-side cursor ? https://wiki.postgresql.org/wiki/Using_psycopg2_with_PostgreSQL#Fetch_Records_using_a_Server-Side_Cursor I met the same problem using pgjdbc with Oracle SQL developer as descibed here https://stackoverflow.com/questio

Re: No commit nor Rollback button

2017-10-16 Thread David G. Johnston
On Mon, Oct 16, 2017 at 11:16 AM, Melvin Davidson wrote: > *You don't need buttons.* > > *Just go to * > *File* > * Preferences* > *SQL Editor* > > *and change Auto commit? to False* > > * and Auto rollback? to False* > > *Or whatever you prefer.* > > *That is what those options are

Re: No commit nor Rollback button

2017-10-16 Thread Melvin Davidson
You don't need buttons. Just go to File  Preferences    SQL Editor and change Auto commit?   to False        and Auto rollback? to False Or whatever you prefer.That is what those options are for! Or learn how to use a TRANSACTION in PostgreSQL.IE: BEGIN; Melvin Davidson 🎸 I reserve the right to

Re: Data grid: fetching/scrolling data on user demand

2017-10-16 Thread legrand legrand
Sorry, why is *select * from information_schema.columns a,information_schema.columns b * on a newly created db is never ending ? when *select * from information_schema.columns a,information_schema.columns b limit 1000* takes less than one second ? Is pgadmin4 really fetching only the 1000 first

Re: No commit nor Rollback button

2017-10-16 Thread legrand legrand
Maybe after 20 years, it is time to switch tool default from autocommit to commit/rollback ... to have a chance to be compared with Oracle SQL developer or others PAscal SQLeo projet manager -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Faded text in pgAdmin 4 2.0/Win Server 2008r2

2017-10-16 Thread Edson Richter
Must be something wrong in my setup: Windows Server 2008 r2 TS, acessing with two Full HD 24" monitors in 32bit color depth., themes disabled, font smoothing enabled, composition enabled, visual effects disabled. I just can't read texts... They are "faded". See attached screenshot for referenc

Re: No commit nor Rollback button

2017-10-16 Thread dangal
for me it would be necessary, if possible thanks a lot -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: Data grid: fetching/scrolling data on user demand

2017-10-16 Thread Dave Page
On Sat, Oct 14, 2017 at 8:24 PM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hello, > > Data grid is populated without any limit by default, > it could be a problem with very big datasets ... > > To avoid this, it is possible to limit the number of rows retrieved, > but that limit is f

Re: No commit nor Rollback button

2017-10-16 Thread Dave Page
On Sat, Oct 14, 2017 at 8:14 PM, legrand legrand < legrand_legr...@hotmail.com> wrote: > Hello, > > Most of RDBMS users don't want to use autocommit mode expecting to have a > change to Rollback in case of problem. > > Most of database GUI have Commit/ Rollback buttons (greyed in autocommit > mode