Re: how to run several versions of pgAdmin on the same pc

2022-09-27 Thread Cherio
Same here. We have a lot of 9.x instances as well. So the choice is either not upgrade or upgrade and have e.g. SquirrelSQL for everything else. On Tue, Sep 27, 2022 at 4:07 PM john fabiani wrote: > I agree - there are plenty of 9.x installs still running. > > Johnf > > On 9/26/22 3:31 AM, Skrol

Re: Content assist / autocomplete hangs the server (latest pgAdmin version)

2022-08-05 Thread Cherio
Joshi wrote: > Hi Cherio > > You can disable the automatic autocomplete option from "File -> > Preferences -> Query Tool -> Auto completion -> Autocomplete on key press". > We have also fixed an issue to stop autocomplete on arrow keys #7573 > <https://redmi

Content assist / autocomplete hangs the server (latest pgAdmin version)

2022-08-03 Thread Cherio
I had to examine certain aspects of a query that looks like this: SELECT COUNT(*) FROM schema.table WHERE id IN ( '1', '2', '3', '19998', '1', '2' ) I pasted the query and autocomplete kicked in. For a minute it froze entirely. Then it sort of let me do things but everything was like

Re: Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Cherio
ture that adds "support for Azure PostgreSQL deployment in server mode". Why is it trying to create new directories in an environment that has nothing to do with Azure? On Mon, Aug 1, 2022 at 11:10 AM Dave Page wrote: > Hi > > On Mon, 1 Aug 2022 at 16:01, Cherio wrote: > &g

Re: Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Cherio
ER_PASSWORD_REQUIRED = False I skipped version 6.11 and upgraded from 6.10 so I can't say whether this broke in 6.11 or 6.12. On Mon, Aug 1, 2022 at 10:09 AM Cherio wrote: > This was just a regular upgrade (I went through dozens of these). > The new 6.12 version fails to start wit

Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Cherio
This was just a regular upgrade (I went through dozens of these). The new 6.12 version fails to start with the following error message: File "lib/python3.8/site-packages/pgadmin4/pgAdmin4.py", line 93, in app = create_app() File "/path-to/opt/pgadmin4/lib/python3.8/site-packages/pgadmin4/

PG Admin 6.1 "flask" compatibility error upon install via python wheel

2021-10-27 Thread Cherio
When installing PGAdmin 6.1 via python wheel I got this error on Ubuntu 20.04, Python 3.8.10 (default, Sep 28 2021, 16:10:42) [GCC 9.3.0] ERROR: flask 1.1.4 has requirement Jinja2<3.0,>=2.10.1, but you'll have jinja2 3.0.2 which is incompatible. Surprisingly pgAdmin4.py still runs and the applica

Re: "Query Tool" is no longer available in a separate browser tab

2021-03-01 Thread Cherio
Ah, moved. Thank you!!! I should start wearing glasses. On Mon, Mar 1, 2021 at 10:58 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Cherio, > > > > On Tue, Mar 2, 2021 at 2:10 AM Cherio wrote: > >> Has the option to open "Query Tool&quo

"Query Tool" is no longer available in a separate browser tab

2021-03-01 Thread Cherio
Has the option to open "Query Tool" in a separate browser tab/window been entirely removed? It was there in version 4.29. I upgraded to 5.0 and the option is no longer there. Personally I am only using the query tool in a separate tab as it gives significantly more visible real estate to work in.

Re: How do I remove this stupid "master password"?

2021-02-28 Thread Cherio
On the one hand angry emails like the one that started this thread reveal how many of users don't realize they should be thankful and appreciative they are given a free product to use. I personally was repelled by the tone, but that's beyond the point. On the other hand this specific question was

Sort by DB size takes a very long time

2021-02-12 Thread Cherio
There seems to be a "suboptimal" implementation of the "Statistics" page when it comes to sorting. I experienced it when sorting by DB "Size" field but it looks like the problem to a lesser extent exists when sorting by other fields as well. Steps to reproduce: 1. Click on the "Databases" node; it

Re: v4.26, produces no output, errors in the log

2020-10-11 Thread Cherio
After all my refreshes and re-installs it seems like Chrome browser issues got on the way. Apologies for the false alarm. On Fri, Oct 9, 2020 at 1:56 AM Akshay Joshi wrote: > Hi Cherio > > Have you execute the query or explain options (explain, explain analyze)? > These options are

Re: v4.26, produces no output, errors in the log

2020-10-08 Thread Cherio
After reinstalling 4.26, clearing everything again and restarting the errors are gone, the data shows but the Explain tab is blank entirely. Those sub-tabs underneath are missing so there is no explain data whatsoever. The logs are clean. On Thu, Oct 8, 2020 at 1:29 PM Cherio wrote: > I j

v4.26, produces no output, errors in the log

2020-10-08 Thread Cherio
I just upgraded pgAdmin from 4.24 to 4.26 (python wheel install) and almost all result tabs are now blank. Neither Query nor Explain produce any result. I cleared all chrome cache (cookies, session/local storage), restarted the backend with no success. I rolled back to 4.24 and everything works as

Re: pgAdmin 4 v4.26 released

2020-09-21 Thread Cherio
Dave, Could you please confirm that the issue only affects the Windows install and not the other ways of setting up pgAdmin. My team is relying on the Python Wheel setup we run on Linux. Thank you. On Mon, Sep 21, 2020 at 6:09 AM Dave Page wrote: > > > On Sat, Sep 19, 2020 at 7:21 AM Dave Page

Re: What does this icon means?

2020-05-04 Thread Cherio
My interpretation is it is telling you which way to look. Sorry :) On Mon, May 4, 2020 at 10:17 AM Edson Richter wrote: > A small arrow at table icon means what? > > > > Thanks, > > Edson >

Re: Is pgadmin4 being developed at Microsoft?

2019-10-14 Thread Cherio
I hate to contribute to a non-constructive subject but sadly pgadmin 4 quality has plenty of room for improvement. I get that impression that development strongly favors new features to stability making the product of the kind of quality I can't trust. I have to wait for each release to be tested b

Re: Forcing "quotes" around Value field in database Parameters sheet

2019-09-20 Thread Cherio
Looks like a regression. This works correctly in 4.10 which is a relatively good release. I am waiting for a release stable enough to upgrade from 4.10. If this is the only regression in 4.13 I might do that On Fri, Sep 20, 2019 at 4:16 AM Milan Oparnica wrote: > Thanks Akshay, done. > > Issue

Re: pgadmin 4 feature behavior change requests

2019-06-27 Thread Cherio
> > 2. Have a sql query check button (unless I'm mistaken, I don't see it) > where it will check if your sql syntax is correct, but wont execute it. > I personally use "Analyze" for that purpose. It seems to be doing exactly that

PgAdmin 4.9, no release notes

2019-06-27 Thread Cherio
Hello, I just received a notification that 4.9 version was released however I could find no corresponding release notes here: https://www.pgadmin.org/docs/pgadmin4/4.x/release_notes.html Thanks

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-05 Thread Cherio
; Sorry, but after an e*xhaustive* search of the several terabytes on my > machine, there is *no* config_local.py file. Do you have any idea where > it's supposed to be located? > > Thanks, > > rik. > > On Wed, Jun 5, 2019 at 9:30 AM Dave Page wrote: > >> >>

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-04 Thread Cherio
Put "MASTER_PASSWORD_REQUIRED = False" line into your "lib/python?.?/site-packages/pgadmin4/config_local.py". This is in the docs: https://www.pgadmin.org/docs/pgadmin4/dev/master_password.html On Tue, Jun 4, 2019 at 4:41 PM richard coleman wrote: > To whomever, > > Running a newly update pgAdmi

Re: pgAdmin v4.7

2019-05-31 Thread Cherio
And this is how I delay installing new releases of PgAdmin 4 one after another. While a release fixes one issue it introduces another. The number of unreliable PgAdmin 4 releases is quite high. On Fri, May 31, 2019 at 6:47 AM Fahar Abbas wrote: > Hi, > > We have already fixed the issue and will

Re: pgAdmin 4.3 scratch pad

2019-03-19 Thread Cherio
This would be a great option to have. Scratchpad can be a nuisance especially due to resizing bug. For some reason nomatter how you resize results panel scratchpad grows in size. On Tue, Mar 19, 2019 at 11:36 AM richard coleman < rcoleman.ascen...@gmail.com> wrote: > Hi All, > > Is there a settin

Re: Issues with results grid with pgadmin4-4

2019-01-11 Thread Cherio
users not being able to rely on its results is a no go to using it. I am glad to hear the fix is on the way. On Fri, Jan 11, 2019 at 10:20 AM Dave Page wrote: > > > On 11 Jan 2019, at 20:28, Cherio wrote: > > This build shouldn't really be called a stable production rele

Re: Issues with results grid with pgadmin4-4

2019-01-11 Thread Cherio
This build shouldn't really be called a stable production release. An issue like this makes it completely unusable. On Fri, Jan 11, 2019 at 8:20 AM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Martin, > > This is an issue and is raised on redmine - > https://redmine.postgresq

Editing boolean table value from keyboard

2018-11-27 Thread Cherio
When I right click on a table and select "View/Edit Data" I can edit fields from keyboard with the exception of boolean fields. There seem to be no key that could toggle boolean values. It is currently only possible by using mouse. This breaks the flow a bit. My usual routine is to start with the

Re: F5 reloading page in 3.5

2018-11-25 Thread Cherio
I also run it in Chrome/XFCE and this has been a bug since the beginning of v4. I ended up simply remapping all actions based on F5. I use F7/F8 to run plan/query. I noticed that from time to time query edit box out of the blue loses focus e.g. as I type SELECT it stops typing and I discover that

Re: Is there any way to get pgadmin4-v3 to work on a non-gnome linux platform

2018-06-06 Thread Cherio
It has no issues running in xfce. I did a standard python wheel set up on 2 xfce workstations. It runs in Chrome well. As often happens it had issues converting configuration from the previous version but has no issues specific to graphic environment. On Wed, Jun 6, 2018 at 6:15 AM Raymond O'Donne

Re: pgadmin4.3 - login failure

2018-04-20 Thread Cherio
Please take a look at the issue I filed a few days ago labelled "v4 3.0 connection issues, notices is readonly", it is related https://www.postgresql.org/message-id/CAKHqFkK%3DAm5JBrdxmaFW92PQAf0m5QNsT2TGj7EJ2fBRgfAHrA%40mail.gmail.com On Fri, Apr 20, 2018 at 7:59 AM frankgard < frank.von.postgres

Re: Desktop-mode on Debian

2018-04-18 Thread Cherio
Johann, I run XFCE4 with cairo dock, but I also have a panel at the top with the indicator plugin and the elephant icon shows up there whenever I start pgadmin4. The icon works but not scalable, like the other icons and since my panel size is smaller than default (18 px) the elephant is a bit crop

Re: v4 3.0 connection issues, notices is readonly

2018-04-18 Thread Cherio
oard calls (https://www.pgadmin.org/faq/#5) > - Delete/Rename existing `pgAdmin4.log` file > - Restart pgAdmin4 and try to re-produce the issue > - Zip the log file and > ​upload it on bug ticket. > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprised

v4 3.0 connection issues, notices is readonly

2018-04-17 Thread Cherio
Hello, PgAdmin 4 v3.0 didn't work out of the box on my ubuntu 16.04.4. Both DEB install and python wheel generate errors. I researched the DEB install and determined that the error occurs in "/usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py" on line 313 which reads pg_conn.noti

Re: pgAdmin4 2.0, schema "Aggregates"

2017-11-06 Thread Cherio
7 at 10:34 AM, Khushboo Vashi < > khushboo.va...@enterprisedb.com> wrote: > >> >> >> On Sat, Nov 4, 2017 at 1:10 AM, Cherio wrote: >> >>> After switching from desktop version 3 to the latest 4 2.0 I noticed >>> that "Aggregates" no

pgAdmin4 2.0, schema "Aggregates"

2017-11-03 Thread Cherio
After switching from desktop version 3 to the latest 4 2.0 I noticed that "Aggregates" node is missing from schemas. It is also missing in "Preferences"->"Browser"->"Nodes". I am not sure if this is a bug or an issue with my local environment or it has not been implemented. Thanks!