Thread: Bug in pgAdmin 3 1.23.0a LTS
Hi, there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I Drag&Drop a script into the editor. The script is read in fine but the editor doesn't remember the name of the file. So when I want to save the changes, I need to select the allready existing file and get asked if I want to overwrite it. That would be just a bit anoying. When I afterwards drop another file in the same editor panel, it gets read in fine, too. But now the panel has still the filename of the first file. On save the first file gets overwritten with the contents of the second file. regards Andreas
On Sat, Dec 3, 2016 at 12:35 AM, Andreas <maps.on@gmx.net> wrote: > Hi, > there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I > Drag&Drop a script into the editor. pgAdmin 3 is no longer supported I'm afraid. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Am 03.12.2016 um 02:00 schrieb Dave Page:> On Sat, Dec 3, 2016 at 12:35 AM, Andreas <maps.on@gmx.net> wrote:>> Hi,>> thereappears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I>> Drag&Drop a script into the editor.>> pgAdmin 3 is nolonger supported I'm afraid. yes, but there is this V1.23 LTS of BigSQL. Sorry, I'm not quite up to speed about who is who. Up until now I had PG from EnterpriseDB and pgAdmin3 which is rather well doing what it needs to do. pgAdmin 4 ... well it's nice to look at but besides that I couldn't drag & drop SQL-files into it's editor at all. I couldn't even figure out how to search&replace something in the editor. At least Ctrl F wouldn't do and there is no icon to click either. :(
On Sat, Dec 3, 2016 at 1:41 AM, Andreas <maps.on@gmx.net> wrote: > Am 03.12.2016 um 02:00 schrieb Dave Page: >> On Sat, Dec 3, 2016 at 12:35 AM, Andreas <maps.on@gmx.net> wrote: >>> Hi, >>> there appears to be a bug in bug in pgAdmin 3 1.23.0a LTS when I >>> Drag&Drop a script into the editor. >> >> pgAdmin 3 is no longer supported I'm afraid. > > yes, but there is this V1.23 LTS of BigSQL. That is nothing to do with us. > Sorry, I'm not quite up to speed about who is who. > Up until now I had PG from EnterpriseDB and pgAdmin3 which is rather well > doing what it needs to do. > > pgAdmin 4 ... well it's nice to look at but besides that I couldn't drag & > drop SQL-files into it's editor at all. No, that's not currently supported. > I couldn't even figure out how to search&replace something in the editor. > At least Ctrl F wouldn't do and there is no icon to click either. That is resolved for 1.2 however. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Am 03.12.2016 um 03:13 schrieb Dave Page: > On Sat, Dec 3, 2016 at 1:41 AM, Andreas <maps.on@gmx.net> wrote: >> Am 03.12.2016 um 02:00 schrieb Dave Page: >>> On Sat, Dec 3, 2016 at 12:35 AM, Andreas <maps.on@gmx.net> wrote: >> yes, but there is this V1.23 LTS of BigSQL. > That is nothing to do with us. Their Installer is on the PostgreSQL.org download-page. Yesterday I didn't pay enough attention and grabbed the first installer-link I saw. > No, that's not currently supported. The v1.1 that I got now in the EnterpriseDB-installer of PG can read scripts by drag&drop. I'm rather sure the v1.1 I got yesterday couldn't. It reads the script into the editor but the editor doesn't remember where it came from. So one drops a file from deep in the folder-tree and to save it again one has to traverse the whole tree from the root to get to the right folder. >> I couldn't even figure out how to search&replace something in the editor. >> At least Ctrl F wouldn't do and there is no icon to click either. > > That is resolved for 1.2 however. Where can I get the 1.2? An editor without search&replace is a wee bit suboptimal. BTW is there a plan to get free floating editor-windows again? Having them restricted to just the pgAdmin window is not really helpful with more than one monitor. regards Andreas
On Sat, Dec 3, 2016 at 2:44 AM, Andreas <maps.on@gmx.net> wrote: > Am 03.12.2016 um 03:13 schrieb Dave Page: >> >> On Sat, Dec 3, 2016 at 1:41 AM, Andreas <maps.on@gmx.net> wrote: >>> >>> Am 03.12.2016 um 02:00 schrieb Dave Page: >>>> >>>> On Sat, Dec 3, 2016 at 12:35 AM, Andreas <maps.on@gmx.net> wrote: > > >>> yes, but there is this V1.23 LTS of BigSQL. >> >> That is nothing to do with us. > > > Their Installer is on the PostgreSQL.org download-page. > Yesterday I didn't pay enough attention and grabbed the first installer-link > I saw. Right, but it's not on pgadmin.org. >> No, that's not currently supported. > > > The v1.1 that I got now in the EnterpriseDB-installer of PG can read scripts > by drag&drop. > I'm rather sure the v1.1 I got yesterday couldn't. That's odd - they're the same code. It's possible one of the devs made D&D work despite it not being a requirement. <tests>.... Hmm, yes - it does seem to work on macOS, both in desktop and server modes. > It reads the script into the editor but the editor doesn't remember where it > came from. So one drops a file from deep in the folder-tree and to save it > again one has to traverse the whole tree from the root to get to the right > folder. Yeah :-( >>> I couldn't even figure out how to search&replace something in the editor. >>> At least Ctrl F wouldn't do and there is no icon to click either. >> >> >> That is resolved for 1.2 however. > > > Where can I get the 1.2? > An editor without search&replace is a wee bit suboptimal. It's not out yet, but you can get the code from the GIT repo (https://git.postgresql.org/gitweb/?p=pgadmin4.git). You should be able to just replace the web/ directory in your installation with web/ from the repo, as long as you keep the config*.py files. Backup everything first though, in case it goes wrong. > BTW is there a plan to get free floating editor-windows again? > Having them restricted to just the pgAdmin window is not really helpful with > more than one monitor. It's on the TODO list, yes. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Am 03.12.2016 um 05:06 schrieb Dave Page: > On Sat, Dec 3, 2016 at 2:44 AM, Andreas <maps.on@gmx.net> wrote: >> Am 03.12.2016 um 03:13 schrieb Dave Page: >> Where can I get the 1.2? >> An editor without search&replace is a wee bit suboptimal. > > It's not out yet, but you can get the code from the GIT repo > (https://git.postgresql.org/gitweb/?p=pgadmin4.git). You should be > able to just replace the web/ directory in your installation with web/ > from the repo, as long as you keep the config*.py files. Backup > everything first though, in case it goes wrong. Sorry to bother you, but I'm stuck. I'm no fit with git and what to in detail but I managed to git clone pgadmin4 to a Linux VM. git clone git://git.postgresql.org/git/pgadmin4.git Then moved the web-folder to the place where it is in the PG-Tree on my windows box. When I start pgAdmin4 now, I get an error: An error occured initialising the application server: Failed to launch the application server, server thread exiting. Then a dialog appears and asks for Python Path and Application Path. I entered the paths acording the README as: f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\Lib\site-packages;f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\Lib;f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\Lib\lib-tk;f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\DLLs f:\programme\PostgreSQL\9.6\pgAdmin 4\web\ No luck :( > It's on the TODO list, yes. Btw. The editor in pgAdmin3 has the option to show SQL keywords in capital letters. Is this on the wishlist allready?
Oh sorry - I forgot there's a change in the required dependencies for Python (so you should roll back your changes). When I'm back in the office tomorrow, I'll see if I can roll you a custom build. Please remind me if I forget!
Thanks.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Am 03.12.2016 um 05:06 schrieb Dave Page:On Sat, Dec 3, 2016 at 2:44 AM, Andreas <maps.on@gmx.net> wrote:Am 03.12.2016 um 03:13 schrieb Dave Page:Where can I get the 1.2?An editor without search&replace is a wee bit suboptimal.It's not out yet, but you can get the code from the GIT repo(https://git.postgresql.org/gitweb/?p=pgadmin4.git). You should beable to just replace the web/ directory in your installation with web/from the repo, as long as you keep the config*.py files. Backupeverything first though, in case it goes wrong.
Sorry to bother you, but I'm stuck.
I'm no fit with git and what to in detail but I managed to git clone pgadmin4 to a Linux VM.
git clone git://git.postgresql.org/git/pgadmin4.git
Then moved the web-folder to the place where it is in the PG-Tree on my windows box.
When I start pgAdmin4 now, I get an error:
An error occured initialising the application server:
Failed to launch the application server, server thread exiting.
Then a dialog appears and asks for Python Path and Application Path.
I entered the paths acording the README as:
f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\Lib\site-packages;f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\Lib;f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\Lib\lib-tk;f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\DLLs
f:\programme\PostgreSQL\9.6\pgAdmin 4\web\
No luck :(It's on the TODO list, yes.
Btw. The editor in pgAdmin3 has the option to show SQL keywords in capital letters. Is this on the wishlist allready?
I put a build at https://developer.pgadmin.org/~dpage/pgadmin4-1.1-x86.exe. There's a Mac build there as well for anyone that wants it: https://developer.pgadmin.org/~dpage/pgadmin4-1.1.dmg Both are *completely untested*. On Mon, Dec 5, 2016 at 2:12 AM, Dave Page <dpage@pgadmin.org> wrote: > Oh sorry - I forgot there's a change in the required dependencies for Python > (so you should roll back your changes). When I'm back in the office > tomorrow, I'll see if I can roll you a custom build. Please remind me if I > forget! > > Thanks. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK:http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > On 4 Dec 2016, at 04:41, Andreas <maps.on@gmx.net> wrote: > > Am 03.12.2016 um 05:06 schrieb Dave Page: > > On Sat, Dec 3, 2016 at 2:44 AM, Andreas <maps.on@gmx.net> wrote: > > Am 03.12.2016 um 03:13 schrieb Dave Page: > > > Where can I get the 1.2? > > An editor without search&replace is a wee bit suboptimal. > > > It's not out yet, but you can get the code from the GIT repo > > (https://git.postgresql.org/gitweb/?p=pgadmin4.git). You should be > > able to just replace the web/ directory in your installation with web/ > > from the repo, as long as you keep the config*.py files. Backup > > everything first though, in case it goes wrong. > > > Sorry to bother you, but I'm stuck. > > I'm no fit with git and what to in detail but I managed to git clone > pgadmin4 to a Linux VM. > git clone git://git.postgresql.org/git/pgadmin4.git > > Then moved the web-folder to the place where it is in the PG-Tree on my > windows box. > > When I start pgAdmin4 now, I get an error: > An error occured initialising the application server: > Failed to launch the application server, server thread exiting. > > Then a dialog appears and asks for Python Path and Application Path. > I entered the paths acording the README as: > > f:\programme\PostgreSQL\9.6\pgAdmin > 4\venv\Lib\site-packages;f:\programme\PostgreSQL\9.6\pgAdmin > 4\venv\Lib;f:\programme\PostgreSQL\9.6\pgAdmin > 4\venv\Lib\lib-tk;f:\programme\PostgreSQL\9.6\pgAdmin 4\venv\DLLs > > f:\programme\PostgreSQL\9.6\pgAdmin 4\web\ > > No luck :( > > > > It's on the TODO list, yes. > > > Btw. The editor in pgAdmin3 has the option to show SQL keywords in capital > letters. Is this on the wishlist allready? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company