[pgadmin-support] REVOKE PRIVILEGES in SQL tab of selected function

2017-06-16 Thread mammoth.power
Let's say we have this function: CREATE OR REPLACE FUNCTION public.test(in_value character varying) RETURNS character varying LANGUAGE 'plpgsql' COST 100.0 VOLATILE LEAKPROOF SECURITY DEFINER AS $$ BEGIN RETURN in_value; END; $$; ALTER FUNCTION public.test(character varying) OWNER

[pgadmin-support] Counter of elements (X) inside subnodes under schema nodes

2017-05-23 Thread mammoth.power
OK, it is not really a bug. It's more a feature request. At the moment when I expand a schema in the browser, then I see nodes for collations, domains, tables, . It would be nice to see the counter of elements under this nodes. Functions (0), Tables (31), . Sometimes I need manually ex

[pgadmin-support] SQL Formatting: FOR EACH ROW in CREATE TRIGGER sql-statement is not in a new line

2017-05-23 Thread mammoth.power
It looks like it was prepared to be displayed as a new line, but the line break is missing. pgAdmin 4 CREATE CONSTRAINT TRIGGER aaa_aid_trigger AFTER INSERT OR DELETE ON bbb.aaa DEFERRABLE INITIALLY DEFERREDFOR EACH ROW WHEN (("ccc"() = 'ddd'::name)) EXECUTE

[pgadmin-support] SQL Font: Bold font and tab width don't match

2017-05-23 Thread mammoth.power
At the moment it looks for example like this: It would be nice to have an option to change the font for better output. Or another embedded font in pgAdmin 4 package. This is how I like it to be displayed (screenshot of notepad++): pgAdmin 4 v1.5 Desktop Runtime Windows 10 x6

Re: [pgadmin-support] making me love pgAdmin III

2017-05-23 Thread mammoth.power
Hi Christoph, it looks like you wish to backup multiple tables from a database at once. That is the use case, that is not implemented at the moment. Or I did not understand it. J Von: Christoph Schreiber [mailto:schrei...@netzwerge.de] Gesendet: Dienstag, 23. Mai 2017 16:15 An: mam

Re: [pgadmin-support] making me love pgAdmin III

2017-05-23 Thread mammoth.power
Hi Christoph, > sorry I meant to backup a single table (not a column) in a schema. This is > possible with pga3 and of course with the pgsql-console but not in pga4. This is possible. Right click on a table in the browser (structure) and select „Backup…“ from the context menu. It looks l

Re: [pgadmin-support] Start of pgAdmin 1.5 takes longer then in 1.4

2017-05-22 Thread mammoth.power
In the log file (temporarily activated) I don’t see any specific problem. It looks like a generally problem. But ok, I only analyzed the timestamps. Today (when I done with sleeping) I will try something else. … 2017-05-23 00:31:46,654: DEBUG pgadmin: Running under the de

Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\'

2017-05-22 Thread mammoth.power
Thanks for the info, I will correct my statements. I have reported it, because syntax highlighting in pgAdmin 3 was able to show it even with single backslash and PostgreSQL returns it visually correct. Result: solved Von: Melvin Davidson [mailto:melvin6...@yahoo.com] Gesendet: Mon

[pgadmin-support] Query Editor: Size of last column can't be increased

2017-05-22 Thread mammoth.power
Some sql statements returns enough columns, that they fill the visual width of "Data Output" grid. At the moment the only way to change column width is: D&D it at the end of column (separator). When I try to increase the width of the last column, then it don't work, because I need to move m

[pgadmin-support] SQL syntax highlightning don't work for single backslash '\'

2017-05-22 Thread mammoth.power
When I have somewhere in text value single backslash char, then everything behind this char will not be highlighted correct. Simple example 1: SELECT '\'; Simple example 2: -- Test 1 SELECT a || '\' || b UNION ALL -- Test 2 SELECT c || '\' || d; Screenshots of sy

[pgadmin-support] Start of pgAdmin 1.5 takes longer then in 1.4

2017-05-22 Thread mammoth.power
The new 1.5 version feels slower than the previous 1.4 version. The durations of second start (with system cache): V1.4 - 21s V1.5 - 33s Like you can see, something take longer at the end of the start. This must be the problem. (I hope the screenshot will not be deleted from messa

[pgadmin-support] Second+ connect with saved password don't work

2017-05-22 Thread mammoth.power
In my database connections I have saved database passwords. When I start pgAdmin, then I can automatically connect to a database. When I disconnect and try to connect again, then I get following Message with password request: fe_sendauth: no password supplied Please enter the pa