[pgadmin-support] SQL window bracket control
When rewriting or error searching a poorly written SQL statement it's very helpful to get the corresponding left or right bracket. I miss this feature in the PGAdmin 4 query tool and I hope it will show up in a coming release. Best regards Oscar -- View this message in context: http://postgresql.nabble.com/SQL-window-bracket-control-tp5925672.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Server status report in PGAdmin 4
On Wed, Oct 12, 2016 at 4:38 AM, Oscar wrote: > Thank you for the big job you have put in to PGAdmin 4. I'v already > experienced big improvements in stability compared to PGAdmin 3. > > I'm however missing, or just unable to find, the "Server status" that was > accessed under Tools in 3. Parts of it is in the dashboard but not with the > same good oveview with Query start, locked by and SQL code. This overview > is > very helpful in case of problems with slow responsetimes for end users. > > Is it planned for a coming release? > > BR > Oscar > > When a server is selected, look at the "Statistics" tab. That has more info, but is missing a few things. One of my core uses of pgAdmin was the auto-updating color-coded view of the Backends, as you mention, AND the ability to kill queries and backends. I'm curious to hear some feedback on this as well. Thanks, T
[pgadmin-support] Server status report in PGAdmin 4
Thank you for the big job you have put in to PGAdmin 4. I'v already experienced big improvements in stability compared to PGAdmin 3. I'm however missing, or just unable to find, the "Server status" that was accessed under Tools in 3. Parts of it is in the dashboard but not with the same good oveview with Query start, locked by and SQL code. This overview is very helpful in case of problems with slow responsetimes for end users. Is it planned for a coming release? BR Oscar -- View this message in context: http://postgresql.nabble.com/Server-status-report-in-PGAdmin-4-tp5925483.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] Further feedback
Further feedback: I just had a problem with csv created by pgAdmin4 as a result of a query yesterday: It resulted in a misformed csv: The file should have had 273966 rows and had 273829. Some rows (108) did not end with a linefeed and the next row was appended. The same query (and export) on pgAdmin3 worked correctly. Also: pgAdmin4 segfaulted while exporting the same query today. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
[pgadmin-support] Feedback on pgAdmin4
Thank you for developing what is supposed to be an improvement on pgAdmin3 which was often unstable. After using pgAdmin4 on Debian testing/sid here are a few observations: * The installation is a bit of a pain the neck without a Debian package. * The Dashboard is impressive. * While running a long-running query I miss the time-elapsed indicator on pgAdmin3. The javascript-screen with the running wheel does not impress me. * Usage of the query tool is frustrating: * When I try to open an existing sql-script with the file browser there is now way I can type in the path. The field where the path is shown is greyed out. * Unlike pgAdmin3 it does not keep a history of "recent files" or "recent locations" and goes back to /. To get to something like '/home/js/db_docs/sql/projects/collaboration' from there using the mouse requires too many clicks. * When I arrive at '/home/js/db_docs/sql/projects/collaboration' the filenames are shortened and the only way to see what the full name is, is to hover the mouse over it. When you have 60 or more files in that directory, it is frustrating. * The order of the files in '/home/js/db_docs/sql/projects/collaboration' cannot be changed. Clicking on the "Modified", "Size", or "Name" column header does not change the order. So when you cannot remember the name of the file you worked on yesterday afternoon, it is difficult to see which file is the latest in the list for example. It would be nice if these things can be configured and to have clear documentation on how to do it. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support