Re: [pgadmin-support] pgadminIII version 1.22.2

2016-08-19 Thread Nikolai Zhubr
20.08.2016 1:15, Stephen Cook: On 2016-08-19 16:14, Patrick Headley wrote: While not saying you should do so forever it would be nice to get some bugs fixed in pgAdmin III since pgAdmin 4 is not ready for production use yet. And especially since pgAdmin3 has become unstable in the last few rel

Re: [pgadmin-support] Indexes generated for primary key are not show

2016-05-18 Thread Nikolai Zhubr
Hello all, 18.05.2016 20:09, Ненашев Илья Николаевич wrote: I has wasted a lot of time today has trying to find my autogenerated indexes for primary keys, which are not shown in PGAdmin III browser tree, until write and execute SELECT * FROM pg_indexes i WHERE i.tablename = ; end have seen a

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
Hello, 16.12.2015 16:37, Guillaume Lelarge: [...] Would be quite difficult. And I completely dislike the idea. If you only need the SQL editor, you can already do this by launching PgAdmin directly with the SQL tool. I'm not sure what you mean by "directly with the SQL tool"? Anyway. It could

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
-ow...@postgresql.org <mailto:pgadmin-support-ow...@postgresql.org> [mailto:pgadmin-support-ow...@postgresql.org <mailto:pgadmin-support-ow...@postgresql.org>] *On Behalf Of * ??? *Sent:* 16 December 2015 11:04 AM *To:* Nikolai Zhubr *Cc:* pgadmin-support@postgresq

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
Hello, 16.12.2015 10:04, Владимир Янченко: [...] 2015-12-15 15:33:54 ERROR : ERROR: permission denied for relation pg_database 2015-12-15 15:33:55 ERROR : ERROR: permission denied for relation pg_tablespace 2015-12-15 15:33:56 ERROR : ERROR: permission denied for relation pg_roles 2015-12-1

Re: [pgadmin-support] pgAdmin III - Crash on Startup

2015-12-16 Thread Nikolai Zhubr
Hello, 16.12.2015 5:41, Peter Morrissey: [...] We have tried restarting the server, uninstalling/reinstalling, have tried installing both 64 and 32 bit versions, and have tried versions 9.4.5 and 9.3.10 – all of which give the same result. Currently installed version is 9.4.5 64-bit. Any idea w

Re: [pgadmin-support] Setof-returning function create script bug

2015-11-27 Thread Nikolai Zhubr
Hello Stefan, this bug is (supposed to be) fixed in git, however beta1 binaries were released before the fix. Therefore, you can either wait for beta2 (or whatever release happens next), or rebuild new binaries yourself from git (although building windows binaries from scratch involves quite a

Re: [pgadmin-support] Disable or remove 'drop' button on toolbar

2015-10-12 Thread Nikolai Zhubr
Hello all, 12.10.2015 11:27, Colin Beckingham wrote: [...] I'm also concerned with the "Delete/Drop" right underneath "Disconnect database" in the context menu. The confirmation popup has saved me many times over the years. If it were an option I would disable it. Just my 2 cents... -- Stephen

Re: [pgadmin-support] Repaint lockup in ctlSQLBox::OnPositionStc on windows (Was: SQL-panel causes 100% CPU and lockup on windows)

2015-10-03 Thread Nikolai Zhubr
Hi all, ok, it is broken since this commit: http://git.postgresql.org/gitweb/?p=pgadmin3.git;a=patch;h=b0ecbbca7f77c0f07cff67bba3d2bca28954a1e2 - EVT_STC_UPDATEUI(-1, ctlSQLBox::OnPositionStc) + EVT_STC_PAINTED(-1, ctlSQLBox::OnPositionStc) It appears that in previous version of scintill

[pgadmin-support] Repaint lockup in ctlSQLBox::OnPositionStc on windows (Was: SQL-panel causes 100% CPU and lockup on windows)

2015-10-03 Thread Nikolai Zhubr
Hi all, Ok, I've verified that ctlSQLBox::OnPositionStc() is broken. If I comment the code for highlighting in it (that is, almost all of its body), the problem goes away. I've found quite some problems observed with it and attempted to fix previously, like e.g. the one from 2011: -

Re: [pgadmin-support] SQL-panel causes 100% CPU and lockup on windows (Was Stability and compatability issues on windows xp)

2015-09-29 Thread Nikolai Zhubr
Hi, 29.09.2015 1:17, I wrote: [...] Here is how to reproduce. (Procedure valid at least for win xp and 7) In under 1 minute! Some more observations. Same problem happens also in function properties window, in the 'Code' tab: - choose some simple (lets say empty) function, open its properties

[pgadmin-support] SQL-panel causes 100% CPU and lockup on windows (Was Stability and compatability issues on windows xp)

2015-09-28 Thread Nikolai Zhubr
Hi, (and sorry for cross-posting, the issue is imo pretty important) 27.09.2015 14:12, I wrote: [...] Besides, I suspect that with some luck the problem might also trigger on vista+ when running pgadmin through a remote desktop, although I'm not quite sure. Ok, no need for remote desktop even.

Re: [pgadmin-support] Stability and compatability issues on windows xp

2015-09-27 Thread Nikolai Zhubr
Hi, 27.09.2015 8:20, J.F. Oster wrote: Hello, NZ> So, is it planned e.g. to publish some beta windows binaries? +1 for publishing beta binaries. NZ> I'm on windows xp sp3 (32-bit). Windows XP is not supported officially, http://www.pgadmin.org/download/windows.php From v1.16.0, Windows

Re: [pgadmin-support] Stability and compatability issues on windows xp

2015-09-26 Thread Nikolai Zhubr
Hi again, and still again regarding this, as I have just discovered that 1.22 beta is probably to be out soon (by looking through last git commits), maybe it is a good time to test and even fix something? So, is it planned e.g. to publish some beta windows binaries? If not, would it make sen

Re: [pgadmin-support] Stability and compatability issues on windows xp

2015-09-26 Thread Nikolai Zhubr
Hi, 26.09.2015 21:41, melvin6925 write: Not sure if it helps, but I have pgadmin 1.18 running fine on win xp. Have you tried reinstalling it? Just tried also 1.18.0, in hope it could be better. Nope. The same CPU usage/responsiveness issue, although it seemingly takes some more time to trig

[pgadmin-support] Stability and compatability issues on windows xp

2015-09-26 Thread Nikolai Zhubr
Hi all, I've recently upgraded from postgresql 9.0 (with pgadmin 1.12 of that time) to most current 9.4.4-3 binary windows release from enterprisedb. And surprisingly, I'm now fighting hard with the new pgadmin. I'm on windows xp sp3 (32-bit). The issues are: - pgadmin from enterprisedb's bi