Thread: pgAdmin III woes (on linux)
i'm sorry, but this is nothing but the immediate expression of my frustration with pgAdmin III: i thought this tool was quasi the "official" postgres GUI and tried to use it to edit larger text fields. maybe it's my fault but the standard procedures to use a GUI to edit text (copy/paste behaviour, click/doubleclick behaviour, sizing of edit fields, etc) are a nightmare in pgAdmin III, at least in debian 6 with gnome (pgAdmin III version 1.10.5). it's always endless fiddling with unexpected results. i have been using linux GUI programs for years with no problems. i know this is far from a usable description of an error condition, i just want to know if others have had a similar experience thx for gentle replies matthias
I've been using pgAdmin III version 1.12.2 under Windows 7 (PostgreSQL 9.0.2) for quite a while and find that it does whateverI need it to. Granted I don't push it that hard, but it seems to get the job done for me with very little in theway of problems. I don't know if the problems you are experiencing are strictly linux related either because I don'tuse that environment. Sorry I can't be more help there. I don't know if it's an option for you to roll back to 1.12.2 or not, but it's a thought. Regards, Chris -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Matthias Leopold Sent: Thursday, June 09, 2011 8:38 AM To: pgsql-novice@postgresql.org Subject: [NOVICE] pgAdmin III woes (on linux) i'm sorry, but this is nothing but the immediate expression of my frustration with pgAdmin III: i thought this tool was quasi the "official" postgres GUI and tried to use it to edit larger text fields. maybe it's my fault but the standard procedures to use a GUI to edit text (copy/paste behaviour, click/doubleclick behaviour, sizing of edit fields, etc) are a nightmare in pgAdmin III, at least in debian 6 with gnome (pgAdmin III version 1.10.5). it's always endless fiddling with unexpected results. i have been using linux GUI programs for years with no problems. i know this is far from a usable description of an error condition, i just want to know if others have had a similar experience thx for gentle replies matthias -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice
On Friday 10 June 2011 01:37:31 Matthias Leopold wrote: Leopold: having used pgadmin3 for many years in linux, currently on a project with 30 odd schemas and hundreds of tables I have great respect for it as a tool. Wheras its easy to edit text fields whose contents are not long, I don't think its designers intended this to be a prime function - certainly trying to edit or copy a field with large contents is difficult however if you must do this for some reason just make the rows higher. Usually field editing like this would be done by whatever language/gui intereface you are using to access the data from postgres, not via pgadmin itself. You can also of course just run an update query in a pgadmin window. Personally if I have to maintain lookup tables I just write a little gui application to do it. However a suggestion which I find very useful for doing more complex things with postgres: pay real money for the postgres product from these poeple: http://www.sqlmanager.net/downloads - I've worked on a number of open source projects and when I need to do complex things quickly or debug functions - this is a fantastic tool - I think you can download a trial version - I just run it in virtual box. Its gui query designer is second to none and far far far better than the one in pgAdmin3. I've paid real money for this and the upgrades and its worth every cent. You can just copy/paste from linux > windows > linux as you need to. kind regards richard > i'm sorry, but this is nothing but the immediate expression of my > frustration with pgAdmin III: > > i thought this tool was quasi the "official" postgres GUI and tried to > use it to edit larger text fields. maybe it's my fault but the standard > procedures to use a GUI to edit text (copy/paste behaviour, > click/doubleclick behaviour, sizing of edit fields, etc) are a nightmare > in pgAdmin III, at least in debian 6 with gnome (pgAdmin III version > 1.10.5). it's always endless fiddling with unexpected results. i have > been using linux GUI programs for years with no problems. > > i know this is far from a usable description of an error condition, i > just want to know if others have had a similar experience > > thx for gentle replies > matthias >