[pgadmin-support] SQL window bracket control

2016-10-12 Thread Oscar
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

2016-10-12 Thread Terry Schmitt
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

2016-10-12 Thread Oscar
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

2016-10-12 Thread Johann Spies
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

2016-10-12 Thread Johann Spies
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