Обсуждение: pgaccess problems
Hello, while trying pgaccess, I have encountered two problems: a) I did not figure out how to specify username, host etc. from the command line b) With 100dpi fonts most dialogs are messed up and cannot be used; eg. in the "open" dialog the "password" entry field is not displayed While a) is only annoying, b) makes pgaccess unusable. Questions: 1) Is there a way to make pgaccess usable with 100dpi fonts? 2) if not, is there some other comparable tool that runs on Linux? Thanks, Christoph Dalitz
On Mon, 8 Jul 2002, Christoph Dalitz wrote: > Hello, > > while trying pgaccess, I have encountered two problems: > > a) I did not figure out how to specify username, host etc. from > the command line Hmmm...I thought this worked but I just checked and it's only the host, port and database that may be specified on the command line. > > b) With 100dpi fonts most dialogs are messed up and cannot be > used; eg. in the "open" dialog the "password" entry field is not displayed Yes, you should be able to change fonts using the preferences. Unfortunately the way place, the geometry manager, works is not compatible with dynamically sizing of windows to suit different settings, like font sizes, unless the application codes it. This is the manager that vTcl uses and I believe the originator of pgaccess used to vTcl to design the windows. Whilst I agree that having vTcl can make laying out windows easier I have always prefered the pack geometry manager which allows applications to adjust themselves to such things without the application having to do the work. But then I am a great believer in the X11 tradition that the application knows diddley squat about how a user wants it to look. There are of course advantages to using place such as easy and consistent postioning or widgets. So, I suggest you try and set a smaller font size in preferences. My default causes the password field to only just be visible at the bottom of the open dialog so I have changed the font and everything has become visible. An alternate is that the tab key will cycle keyboard focus through the entry fields in a dialog. For the open database dialog the fields are Host, Port, Database, Username and Password. So, starting with the Host field having focus you can get to the Password field by hitting tab 4 times. > > While a) is only annoying, b) makes pgaccess unusable. > > Questions: > > 1) Is there a way to make pgaccess usable with 100dpi fonts? I think the answer to that is probably no unless you go through the source code and make every window that's not already resizeable to be so and the change the widget placements to be relative rather than absolute. > 2) if not, is there some other comparable tool that runs on Linux? I hear pgAdminII is good but I also think that is MS Windows only. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants
[added pgsql-interfaces@... to distribution list due to the question in my last paragraph] On Mon, 8 Jul 2002, Christoph Dalitz wrote: > On Mon, 8 Jul 2002 11:12:17 +0100 (BST) > "Nigel J. Andrews" <nandrews@investsystems.co.uk> wrote: > > > > Hmmm...I thought this worked but I just checked and it's only the host, port > > and database that may be specified on the command line. > > > How do you specify host, port and database? > The man page says, only the database can be specified. > > [edited] > Ah, I only quickly scanned the source. Yes you are correct, only the database may be specified on the command line. BTW, I think the web site for pgaccess is www.pgaccess.org and there should be some development work being done on pgaccess now. Talking of which, has the patched/updated version of pgaccess been placed into the main CVS tree yet or what was the planned for the distribution mechanism? -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants
Nigel J. Andrews wrote: > On Mon, 8 Jul 2002, Christoph Dalitz wrote: > > > Hello, > > > > while trying pgaccess, I have encountered two problems: > > > > a) I did not figure out how to specify username, host etc. from > > the command line > > Hmmm...I thought this worked but I just checked and it's only the host, port > and database that may be specified on the command line. > > > > > b) With 100dpi fonts most dialogs are messed up and cannot be > > used; eg. in the "open" dialog the "password" entry field is not displayed > > Yes, you should be able to change fonts using the preferences. Unfortunately > the way place, the geometry manager, works is not compatible with dynamically > sizing of windows to suit different settings, like font sizes, unless the > application codes it. This is the manager that vTcl uses and I believe the > originator of pgaccess used to vTcl to design the windows. > > Whilst I agree that having vTcl can make laying out windows easier I have > always prefered the pack geometry manager which allows applications to adjust > themselves to such things without the application having to do the work. But > then I am a great believer in the X11 tradition that the application knows > diddley squat about how a user wants it to look. There are of course advantages > to using place such as easy and consistent postioning or widgets. Yes, 'pack' is one of the coolest GUI tools I have ever seen, and vtcl can use pack very easily. I have written some vtcl apps, they all use pack, and they all resize just fine. It probably would not be hard to modify pgaccess to use pack, and I would encourage it. There is a pgaccess group working at pgaccess.org. You may want to hook up with them. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Nigel J. Andrews wrote: > BTW, I think the web site for pgaccess is www.pgaccess.org and there should be > some development work being done on pgaccess now. Talking of which, has the > patched/updated version of pgaccess been placed into the main CVS tree yet or > what was the planned for the distribution mechanism? I updated to their most recent release: revision 1.13 date: 2002/07/02 06:11:23; author: momjian; state: Exp; lines: +5 -9 Update to pgaccess 0.91. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Yes, there are development efforts. There are several people dedicated to different areas. The work is not very well coordinated at the moment. -- Iavor Raytchev very small technologies (a company of CEE Solutions) in case of emergency - call: + 43 676 639 46 49 or write to: support@verysmall.org www.verysmall.org
> Nigel J. Andrews wrote: > > BTW, I think the web site for pgaccess is www.pgaccess.org and > there should be > > some development work being done on pgaccess now. Talking of > which, has the > > patched/updated version of pgaccess been placed into the main > CVS tree yet or > > what was the planned for the distribution mechanism? The patched version has not been sent yet to PostgreSQL. There are plans to release 0.98.8 together with PostgreSQL 7.3 Currently the effort around this is being organized. Iavor