Is it possible to switch off 'Waiting for the query to complete..."? screen saver ?

2019-09-07 Thread Petr Fedorov
Hello I run a long-running stored procedure which uses RAISE statements to output debug information. I do see the messages behind "Waiting for the query to complete ..." window, but when the query ends (with ERROR), Messages window is cleared and only the latest message is displayed there.  This i

pgAdmin4 can't re-attach some previously detached partition

2019-04-11 Thread Petr Fedorov
Hello, I recognized that for some reasons pgAdmin4 does not allow to re-attach some of the previously detached partitions: Here is the test script to reproduce: create table test (id integer, col1 integer, col2 integer) partition by list (id); create table test1 partition of test for values in

Re: Browser in pgAdmin4 v3.6 is not able to show either Function or Trigger function in Release 11 database

2019-01-23 Thread Petr Fedorov
Hello, I managed to resolve the issue by re-creation of server node in pgAdmin4's browser. It seems that pgAdmin kept somewhere locally  that the version of the server is 10 (I did an upgrade) - so it was using wrong templates for sql queries. 23.01.2019 19:10, Petr Fedorov пишет: >

Browser in pgAdmin4 v3.6 is not able to show either Function or Trigger function in Release 11 database

2019-01-23 Thread Petr Fedorov
Hello! I'm on Centos 7 and just migrated to Release 11 (from 10) using official repository and re-installed pgAdmin4 v.3.6 from there too.   Suddenly I'm not able to see in browser Function and Tr

"Statistics" tab is very slow

2019-01-08 Thread Petr Fedorov
Hello, I'm using pgAdmin 4 version 3.6 on Centos 7, Postgresql 10.6 runs on the same machine. I use local connections. Almost everything works fine except for 'Statistics' tab when viewing pgAgent job log. It takes 60-90 seconds to load, the whole pgAdmin4 is frozen during the load, Firefox shows

Is CREATE AGGREGATE supported by pgAdmin4?

2018-10-16 Thread petr . fedorov
Hi, Is editing of custom aggregates supported by pgAdmin4?I couldn't find either node in pgAdmin4 tree nor the option to turn it on -- there used to be one in pgAdmin3 .