Re: [EXTERNAL] - Re: pgAdmin IV

2019-06-04 Thread Aditya Toshniwal
Hi Michelle, On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan wrote: > Aditya, > > > > That is not very intuitive! Why can’t the information be displayed? All > of the other database tools for other databases allow this. > This can be done if we split the JSON data and show it in multiple rows.

Re: pgAdmin IV

2019-06-04 Thread Khushboo Vashi
Hi, Please log the issue @ https://redmine.postgresql.org/projects/pgadmin4 Thanks, Khushboo On Tue, Jun 4, 2019 at 7:46 PM Michelle Schwan wrote: > In versions 4.7 and 4.8 I am getting an error when trying to import a csv > file into a table. > > > > The CSV file loads in pgAdmin III with no

Re: pgAdmin in text only

2019-06-04 Thread Khushboo Vashi
On Tue, Jun 4, 2019 at 8:00 PM wrote: > > > Hi there, > > > > Trying to install PostgreSQL 9.6 and pgAdmin4 on Centos 7 for lab testing > purposes but some these is the web interface that I am getting at for > localhost/pgadmin4. I believe I was to display it properly last two weeks > ago but si

Re: centos 7 / pgadmin 4.7

2019-06-04 Thread Khushboo Vashi
Hi Alex, Can you please test the latest packages released by the packager as mentioned in the RM https://redmine.postgresql.org/issues/4313? Thanks, Khushboo On Tue, Jun 4, 2019 at 10:03 PM Alex Williams wrote: > Also, I've updated the ticket with the info below and the solution from > Mike is

Re: pgAdmin4 4.8 Kubuntu issues

2019-06-04 Thread Michel Feinstein
It would be easier if the system when prompting for the Master Password, had a "I don't want to define a Master Password" or something like that, which would set that config_local.py property automatically. On Tue, Jun 4, 2019, 18:06 Cherio wrote: > Put "MASTER_PASSWORD_REQUIRED = False" line in

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

pgAdmin4 4.8 Kubuntu issues

2019-06-04 Thread richard coleman
To whomever, Running a newly update pgAdmin 4 version 4.8 on my Kubuntu box. There are a couple of glaring issues. First: It keeps prompting to; "Set Master Password" I don't want to set another password that I'll just end up forgetting. Second: When I click the "?" button on that dialog bo

RE: [EXTERNAL] - Re: pgAdmin IV

2019-06-04 Thread Michelle Schwan
Aditya, That is not very intuitive! Why can’t the information be displayed? All of the other database tools for other databases allow this. Thanks, Michelle From: Aditya Toshniwal Sent: Tuesday, June 04, 2019 10:50 AM To: Michelle Schwan Cc: pgadmin-support lists.postgresql.org Subject: [E

Re: centos 7 / pgadmin 4.7

2019-06-04 Thread Alex Williams
Also, I've updated the ticket with the info below and the solution from Mike is working: yum downgrade pgadmin4-python-flask https://redmine.postgresql.org/issues/4313 [root@centos7dev output]# yum downgrade pgadmin4-python-flask Loaded plugins: fastestmirror, langpacks Loading mirror speeds fr

Re: centos 7 / pgadmin 4.7

2019-06-04 Thread Alex Williams
Also, if I try to open those javascripts directly, I get the following responses: require.min.js: info "" errormsg "make_conditional() got an unexpected keyword argument 'accept_ranges'" data null result null success 0 vendor.js: nfo "" errormsg "make_conditional() got an unexpected keyword

Re: centos 7 / pgadmin 4.7

2019-06-04 Thread Alex Williams
Thank you bothalso, here's is the console output when opening pgadmin on the browser: Loading failed for the

Re: pgAdmin IV

2019-06-04 Thread Aditya Toshniwal
You need to double click on the "[" cell. It is a json data. Thanks, Aditya Toshniwal On Tue, Jun 4, 2019, 20:10 Michelle Schwan wrote: > This is in all versions of pgAdmin IV. > > > > When generating an explain plan for a query, the data output only returns > “[“. In pgAdmin III, there was

pgAdmin IV

2019-06-04 Thread Michelle Schwan
This is in all versions of pgAdmin IV. When generating an explain plan for a query, the data output only returns "[". In pgAdmin III, there was a detailed output. It is easier to read the detailed data output than the explain pictures - I have to keep my mouse on the picture to read it, very in

pgAdmin in text only

2019-06-04 Thread jidjan
Hi there, Trying to install PostgreSQL 9.6 and pgAdmin4 on Centos 7 for lab testing purposes but some these is the web interface that I am getting at for localhost/pgadmin4. I believe I was to display it properly last two weeks ago but since V4.7 this is the display that I am getting at.

pgAdmin IV

2019-06-04 Thread Michelle Schwan
>From version pgAdmin IV 4.6 and up, I am now receiving the following error >message when I import a database into PostgreSQL. [cid:image001.png@01D51AC0.3A964FB0] The database loads fine, but the error that public already exists seems strange. Public is the default schema when creating a datab

pgAdmin IV

2019-06-04 Thread Michelle Schwan
In versions 4.7 and 4.8 I am getting an error when trying to import a csv file into a table. The CSV file loads in pgAdmin III with no issues. The file size is 4,557,820 KB (only 5 columns in the table and 2 indexes). Smaller files load with no issues. [cid:image002.jpg@01D51ABE.814440E0] Th

Re: login role password

2019-06-04 Thread Michael Shapiro
Thanks. That is a helpful workaround. I am asking for this functionality to be added to PgAdmin4, so that when you select the SQL for a login role you see what PgAdmin3 shows. CREATE ROLE xxx_user LOGIN ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09' SUPERUSER INHERIT CREATEDB CREA

Re: login role password

2019-06-04 Thread Isaías Sánchez
Just: select * from pg_authid; En 4 de junio de 2019 15:14:49 Michael Shapiro escribió: PgAdmin3 has the ability to see the encrypted password for a login role. That allow me to copy the login role password from one server to another (without having to know the password). I don't see how to

login role password

2019-06-04 Thread Michael Shapiro
PgAdmin3 has the ability to see the encrypted password for a login role. That allow me to copy the login role password from one server to another (without having to know the password). I don't see how to see the encrypted password for a login role in PgAdmin4

Re: 4.8 docs build error

2019-06-04 Thread Christoph Berg
Re: To pgAdmin III support 2019-06-04 <20190604124400.ga4...@msg.df7cb.de> > The problem is in docs/en_US/build_code_snippet.py: Christoph --- a/docs/en_US/build_code_snippet.py +++ b/docs/en_US/build_code_snippet.py @@ -32,8 +32,7 @@ This document contains code for some of below:\n\n""") for

4.8 docs build error

2019-06-04 Thread Christoph Berg
reading sources... [ 95%] unique_constraint_dialog reading sources... [ 96%] user_interface reading sources... [ 97%] user_management reading sources... [ 98%] user_mapping_dialog reading sources... [ 99%] using_pgagent reading sources... [100%] view_dialog Warning, treated as error: /home/cbe/pr