[pgadmin-support] pgadmin4 - Allow re-opening queries from the history

2017-01-24 Thread Mark Murawski
Say you have a tab: Query-1 open You go to history, and say you have some failed queries you want to retry The full query is truncated in the 'Query' column and there's no options to re-open this query and try again (or edit) -- Sent via pgadmin-support mailing list (pgadmin-support@postgre

[pgadmin-support] pgadmin4 - Don't disable save button after failure while editing table

2017-01-24 Thread Mark Murawski
1) While doing Table -> View Data, and inserting a new row: If you get an error such as a primary key violation on a table that uses a serial... you may have violation where id=1... and you may want to retry because you know that id=2 is available... so the counter will increase and your inser

Re: [pgadmin-support] Cannot compile pgadmin4 mainline

2016-12-15 Thread Mark Murawski
the startup. It's pretty easy to auto detect where the virtualenv tools are located on major distros, and worst-case, it can always fall back to spit out a note saying 'here's how you do it manually'. On 12/13/2016 04:05 AM, Dave Page wrote: On Mon, Dec 12, 2016 at 9

Re: [pgadmin-support] Cannot compile pgadmin4 mainline

2016-12-12 Thread Mark Murawski
64 Nov 1 13:11 flask_sqlalchemy drwxr-xr-x 1 markm markm 154 Nov 1 13:11 flask_wtf I'm using the same path as last time, but it cannot find what it needs... On 12/12/16 04:41, Dave Page wrote: Hi On Mon, Dec 12, 2016 at 1:04 AM, Mark Murawski wrote: (pgadmin4)markm {~/download/p

[pgadmin-support] Cannot compile pgadmin4 mainline

2016-12-11 Thread Mark Murawski
(pgadmin4)markm {~/download/pgadmin4/runtime} kobaz$ git pull Already up-to-date. (pgadmin4)markm {~/download/pgadmin4/runtime} kobaz$ git log | head -n 1 commit 4a280b251755091af9bf56bcdee964601df104ae (pgadmin4)markm {~/download/pgadmin4/runtime} kobaz$ qmake Project MESSAGE: Building for QT5+.

Re: [pgadmin-support] pgAdmin 4.x vs pgAdmin 3.x

2016-11-23 Thread Mark Murawski
More to Add: Core features missing from pgadmin4 -There's no search functionality in the sql-query/function editor -You cannot dynamically change the font size bigger/smaller with ctrl-mouse-scroll -You cannot open a query in a new window -Functions all open up in a tab named 'Query-untitled' w

[pgadmin-support] BUG: Cannot add primary key, etc during create table

2016-11-04 Thread Mark Murawski
pgadmin4 1.1 Problem: Add columns to table in "create table" dialog Navigate to 'primary key' Enter primary key name Cannot select column to primary key on This also is a problem for foreign keys and unique keys -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.or

Re: [pgadmin-support] Can't install pgadmin4 on linux (flask required)

2016-11-02 Thread Mark Murawski
On 11/2/16 8:01 AM, Dave Page wrote: Hi On Tuesday, November 1, 2016, Mark Murawski mailto:markm-li...@intellasoft.net>> wrote: On 11/01/16 12:58, Mark Murawski wrote: The above exception was the direct cause of the following exc

Re: [pgadmin-support] pgAdmin 4 1.1, query error while browsing columns

2016-11-02 Thread Mark Murawski
Make sense. Probably should throw a warning about this and/or refuse to connect. On 11/2/16 10:50 AM, Ben Trewern wrote: Hi, pgAdmin 4 supports PostgreSql 9.2 and above. I guess that’s the problem. Regards, Ben On 2 Nov 2016, at 14:43, Mark Murawski <mailto:markm-li...@intellasoft.

[pgadmin-support] pgAdmin 4 1.1, query error while browsing columns

2016-11-02 Thread Mark Murawski
Working with pgAdmin 4 1.1 on Mac 10.11.5 I connected to a postgres 9.1 database and I'm just clicking around looking at individual columns in the tree within: db schema table col1 col2 ..etc.. If I click on 'col1', I get this: ERROR: syntax error at or near "WH

Re: [pgadmin-support] Can't install pgadmin4 on linux (flask required)

2016-11-01 Thread Mark Murawski
On 11/01/16 12:58, Mark Murawski wrote: Now I'm stuck here: (pgadmin4)markm {~/download/pgadmin4} markm$ pip install -r requirements_py3.txt Downloading/unpacking Babel==1.3 (from -r requirements_py3.txt (line 1)) Downloading Babel-1.3.tar.gz (3.4MB):

Re: [pgadmin-support] Can't install pgadmin4 on linux (flask required)

2016-11-01 Thread Mark Murawski
On 10/30/16 13:13, Dave Page wrote: That email is really quite old - we ignore PYTHONPATH these days (otherwise, if the user has it set for other purposes, it can break pgAdmin). I made some significant updates to the README last week, which you should review - particularly the part about config

[pgadmin-support] Can't install pgadmin4 on linux (flask required)

2016-10-29 Thread Mark Murawski
Hi, So I followed all the instructions so far with pgadmin4 1.1 Debian Jessie Qt5 5.3.2-2 Python 3.4 3.4.2-1 All the requirements are met: markm {/home/markm/download/pgadmin4-1.1} root# pip3 install -r requirements_py3.txt Requirement already satisfied (use --upgrade to upgrade): Babel==1.3

Re: [pgadmin-support] FATAL MISTAKE WITH POSTGRE MANAGER

2010-02-01 Thread Mark Murawski
edit pg_hba.conf make sure you have the following line: local   all postgres  ident sameuser su to the postgres user run psql you should now have full access to the database to add your superuser back again On 02/01/2010 08:55 AM, pedro.prat.du...@everis.com

[pgadmin-support] Feature Request

2009-12-04 Thread Mark Murawski
When you double click on a column, it cycles from collapsed, to the size that fits the longest value. It would be very very useful if it also cycled to a third option, which is: expand to the longest value that also shows the full column name and column type. -- Sent via pgadmin-support ma

[pgadmin-support] Feature request: Refresh data when doing 'create script'

2009-08-13 Thread Mark Murawski
If you - have a query window open - and you're editing a function definition, or trigger - execute the query, and update/replace the function or trigger, or type. or table, or any other object - and then later right click on the object and do 'create script' you'll get the old data that was cac

[pgadmin-support] Feature request: Reget oid of tables/views when doing a reload

2009-08-13 Thread Mark Murawski
When I'm doing heavy development I'm always removing and recreating tables and views. If you - drop a view - create a view with the same name - and have the data window for the view open from before it was dropped - and do a refresh You lose the column names, since the oid for the view/table is

Re: [pgadmin-support] Cannot paste text from eclipse 3.5 to PGAdmin III

2009-07-31 Thread Mark Murawski
Also, along the lines of pasting... You can't copy text from a query editor using the "select a region" method that's standard in X (where you select a bit of text, and then middle click in another window to paste).. This kills the ability to paste into xterms from the query window. But, if y

Re: [pgadmin-support] Need help urgent!!!

2009-07-13 Thread Mark Murawski
I think you're on the wrong list On 07/13/09 15:46, Benjamin Krajmalnik wrote: There is a bug on the php pg libraries for windows. Apparently they are having an issue loading the libraries (started about a year ago with an apparent change in the way the p libraries are compiled).. On my wi

[pgadmin-support] Feature request: On demand Configuration data save

2009-07-11 Thread Mark Murawski
It would be really really great if when you added a new server, or changed local settings, that it wrote out the config file. When pgadmin crashes, you lose any settings changes. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: htt

Re: [pgadmin-support] whoami server feedback (feature request)

2009-07-11 Thread Mark Murawski
Tabs would be cool! On 07/11/09 16:13, Erik Rijkers wrote: Hi, With several servers (e.g. 8.3, 8.4, 8.4devel) open in pgadmin's (1.10) main-screen (object-browser panel), it often becomes difficult to see where you are, because there is no feedback other than in the 'root' object (where the

Re: [pgadmin-support] Unable to edit views

2009-07-11 Thread Mark Murawski
Well, All of my editable views have a unique identifier.  Navicat does warn you, that it will use an all old = new type of update when you edit. On 07/11/09 15:53, Dave Page wrote: On 7/11/09, Mark Murawski wrote: Feature request: Editing of editable views When you view the

[pgadmin-support] Unable to edit views

2009-07-11 Thread Mark Murawski
Feature request:  Editing of editable views When you view the data on a view, nothing is editable.  Navicat in windows supports editing editable views by using an 'update where all columns = old data, set new data' type of query. My projects heavily use editable views, and I'm constantly swit