Re: ordinal not in range when downloading result set as CSV

This issue occurs when you have some encoded data which pgAdmin4 can't decode while generating CSV file. You can report this issue here , Please also include details to produce the issue​ (if possible also include some sample data), PG versi

Re: F5 - irritating behaviour

I've always used F5 to the point that's a reflex. I use pgAdmin4 in a browser, usually Chrome, in server mode and about half the time F5 does what I want (executes the query) and the other half the time it tries to reload the page. It's annoying and I haven't figured out what triggers it. Philosoph

ordinal not in range when downloading result set as CSV

I"m trying to download the result set of a SQL query to csv and I get this error: 'ascii' codec can't encode character u'\ufeff' in position 33: ordinal not in range(128) Any pointers appreciated, thanks. This on Ubuntu 16.04: *Version* 2.0 *Copyright* Copyright 2013 - 2017, The pgAdmin Dev

Re: Output format of explain

On Thu, Nov 2, 2017 at 1:34 PM, Johann Spies wrote: > Maybe because I do not spend enough time in reading the output of > "explain" results, I made use of the website https://explain.depesz.com/ > in the past to quickly identify the problem areas in complicated > queries. > > Now I cannot do it a

Output format of explain

Maybe because I do not spend enough time in reading the output of "explain" results, I made use of the website https://explain.depesz.com/ in the past to quickly identify the problem areas in complicated queries. Now I cannot do it as the output is in json format and there is (as far as I could fi

Re: F5 - irritating behaviour

On Thu, Nov 2, 2017 at 10:44 AM, Dave Page wrote: > > > On Thu, Nov 2, 2017 at 9:35 AM, Johann Spies wrote: > >> On Debian in Firefox >> >> If I terminate a running query, change it and press F5 again, a >> notification jumps up asking me whether I want to leave the page! >> >> Then I have to us

Re: F5 - irritating behaviour

On Thu, Nov 02, 2017 at 09:44:27AM +, Dave Page wrote: > On Thu, Nov 2, 2017 at 9:35 AM, Johann Spies wrote: > > > It sounds like Firefox is grabbing the keypress. That shouldn't happen as > long as the query tool has focus. Is that the case? Yes. After editing the query (after terminating

Re: Multiple head revisions after git pull (2.0rc1 --> 2.0)

I suspect you have some local revisions, Could you run below command and see if you have any local revisions? ../web$ FLASK_APP=pgAdmin4.py flask db history You can compare it with what we(pgadmin4) have in revision history, ... ... d85a62333272 -> ef590e979b0d (head), empty message f195f9a4923d

Re: Multiple head revisions after git pull (2.0rc1 --> 2.0)

Just to clarify, this is not a git question Op 1 nov. 2017 12:19 p.m. schreef "Willy-Bas Loos" : > Hi, > > After my stash & pull to upgrade from 2.0rc1 to 2.0, these commands both > end in the error below. > >- ../web$ FLASK_APP=pgAdmin4.py flask db revision >- ../web$ python pgAdmin4.py

Re: F5 - irritating behaviour

On Thu, Nov 2, 2017 at 9:35 AM, Johann Spies wrote: > On Debian in Firefox > > If I terminate a running query, change it and press F5 again, a > notification jumps up asking me whether I want to leave the page! > > Then I have to use the mouse to activate the query again. > It sounds like Firefo

F5 - irritating behaviour

On Debian in Firefox If I terminate a running query, change it and press F5 again, a notification jumps up asking me whether I want to leave the page! Then I have to use the mouse to activate the query again. I am not actually sure whether it is always after a query was terminated that this happ