Re: [pgadmin-support] We just found another small bug in pgAdmin3
Dave Page wrote: -Original Message- From: Justin Clift [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 06:01 To: Dave Page Cc: Danny Butler Subject: We just found another small bug in pgAdmin3 Hi Dave, Danny (CC'd) here is learning PostgreSQL and PHP, and has just been introduced to the wonders of pgAdmin 3. :) In the Data Grid, he's noticed that multiple rows can be selected at once by holding down the Shift key, but if he then goes and hits the delete icon only one of them is deleted. This is on a different PC from yesterday, and it's version of pgAdmin is a development 1.1.0 snapshot from about a fortnight ago. Thought you'd like to know. Ahh, so it does. I'll forward this to the support list [hint hint :-) ]. A, I know... should join the list. It's just that there's no super easy way of joining a mailing list to report a bug and make sure that people know about it... without having all of the list traffic also come along for the ride. (Guess I'm in a lazy mood at the moment eh?) Ok, if we notice more bugs then we'll do it properly. :) Regards and best wishes, Justin Clift Thanks, Dave. -- Executive Director Digital Distribution Global Training Services Pty. Ltd. Premier OpenOffice.org Online Training providers http://www.digitaldistribution.com ---(end of broadcast)--- TIP 8: explain analyze is your friend
[pgadmin-support] SQL editor thought
Hiyas, Was just running a few queries in the SQL Editor (latest available snapshot version, for Windows), and came across a pain-in-the-butt usability issue. When you have the results for a SQL query show up, you can't then select the resulting cell text, so it can't be cut-n-pasted from there to say, another app. Came across this when searching for user comments in a table with about 400,000 records, with the comments field able to be quite long. Upon finding the comments I was after... I couldn't then cut-n-paste them. Arrrgh! ;-) Thought I'd mention it, in case it's new. Regards and best wishes, Justin Clift -- Executive Director Digital Distribution Global Training Services Pty. Ltd. Premier OpenOffice.org and StarOffice Online Training providers http://www.digitaldistribution.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-support] Troubles compiling latest pgAdmin cvs
Hi all, Just tried compiling pgAdmin (latest from CVS) and am getting compiling errors on Sun Java Desktop System Release 2 (it's pretty much SuSE Linux 8.x). Have successfully first compiled wxWindows from source into /opt/wxwindows and the stc and xrc extras. It was the "wxWindows-pgAdmin3-20031010-7.tar.bz2" so I'm hoping that's right. Had to update autoconf to version 2.58 as well. When compiling pgAdmin, I checked out the latest cvs, ran the "sh bootstrap" and then ran: ./configure --prefix=/opt/pgadmin3 --enable-static --with-wx=/opt/wxwindows --with-pgsql=/opt/pgsql/latest The configure went fine, but the make errored out. The last bit of the erroring out was: *** source='utils/sysSettings.cpp' object='sysSettings.o' libtool=no \ depfile='.deps/sysSettings.Po' tmpdepfile='.deps/sysSettings.TPo' \ depmode=gcc3 /bin/sh ../config/depcomp \ g++ -DHAVE_CONFIG_H -I. -I. -I.. -DDATA_DIR=\"/opt/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -I/opt/pgsql/latest/include -DSSL -I/opt/wxwindows/lib/wx/include/gtk-2.5 -I/opt/wxwindows/include -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -I/opt/wxwindows/include -DDATA_DIR=\"/opt/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -g -O2 -c -o sysSettings.o `test -f 'utils/sysSettings.cpp' || echo './'`utils/sysSettings.cpp source='utils/utffile.cpp' object='utffile.o' libtool=no \ depfile='.deps/utffile.Po' tmpdepfile='.deps/utffile.TPo' \ depmode=gcc3 /bin/sh ../config/depcomp \ g++ -DHAVE_CONFIG_H -I. -I. -I.. -DDATA_DIR=\"/opt/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -I/opt/pgsql/latest/include -DSSL -I/opt/wxwindows/lib/wx/include/gtk-2.5 -I/opt/wxwindows/include -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -I/opt/wxwindows/include -DDATA_DIR=\"/opt/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -g -O2 -c -o utffile.o `test -f 'utils/utffile.cpp' || echo './'`utils/utffile.cpp utils/utffile.cpp: In member function `off_t wxUtfFile::Read(wxString&, long long int)': utils/utffile.cpp:86: no matching function for call to `wxMBConv::MB2WC( wxStringBuffer, char*&, unsigned int)' /opt/wxwindows/include/wx/strconv.h:46: candidates are: virtual size_t wxMBConv::MB2WC(wchar_t*, const char*, unsigned int) const make[2]: *** [utffile.o] Error 1 make[2]: Leaving directory `/home/jc/cvs/pgadmin3/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/jc/cvs/pgadmin3' make: *** [all] Error 2 $ *** Does anyone have any ideas on what could be wrong? Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-support] Bug in generated SQL query definition area?
Hi all, Not sure if this is a bug in pgAdmin or PG, but thought I'd mention it as it's "weird" and easy to check. Using pgAdmin 3 (both v1.0.2 and 1.1.0dev as of 23rd June), if I connect to a PG 7.4.3 database and go to the "information_schema.constraint_column_usage" view, pgAdmin3 shows the SQL definition for this view in the window. If I cut-n-paste this definition into a SQL editing window and tell it to execute, I get the error: ERROR: syntax error at or near "ALL" at character 1353 Looking at the SQL that was shown in the SQL editing window, it appears to not be correct. In this case it's missing a closing ")" which generates the above error. First time I've noticed anything like this with pgAdmin3, and it's happening on two different platforms... version 1.0.2 on Sun Java Desktop System Release 2, and version 1.1.0 dev (latest downloadable) on Win XP. Any ideas? Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-support] Small query builder bug
Hi all, Just downloaded the newest Windows binary snapshot of pgAdmin3 (22nd July 2004), and am trying out the query builder. Works pretty decently, with one repeatable bug: + When the user has dragged database fields into the "Design" tab area, there are options that can be changed for the field. The option "Output" defaults to yes, and can't be changed to No. The drop down works and everything, it's just that choosing "No" doesn't work... it goes straight back to "Yes". Mentioning this bug just in case it's not known about or expected. Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-support] pgAdmin can't connect to port 5432
Hi Michael, In the PostgreSQL data directory on the server, there is a file called "pg_hba.conf". (It stands for PostgreSQL "Host Based Access" configuration I think) This file contains the list of IP addresses plus user names and databases that people are allowed to connect to remotely. The error you're getting indicates that you've connected to the database server, but it's not letting you actually "get in" because your IP address, user name (and so on) isn't listed in this configuration file. You'll need to add your details there, then tell the PostgreSQL server to reload this configuration file: $ pg_ctl reload The configuration file itself is quite a lot of verbose text, describing how to add entries in there. Generally you can just copy an existing entry and change it appropriately. Hope that helps. Regards and best wishes, Justin Clift Michael J Martin wrote: Just to mention the error I get is not a 'process isn't running' error it is: Error connecting to the server: FATAL: no pg_hba.conf entry for host "212.159.49.21", user "mike", database "template1", SSL off Hope this helps. Michael ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-support] Storing configuration in a centralised database?
Hi all, Has any thought been given to storing the pgAdmin configuration in a cental database? That way a central server could hold all of the configuration info for the company databases, and people can connect to that central server which will provide all the needed info for connecting to other databases. ? Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] Storing configuration in a centralised database?
Andreas Pflug wrote: That way a central server could hold all of the configuration info for the company databases, and people can connect to that central server which will provide all the needed info for connecting to other databases. IMHO, it's not worth the effort. pgAdmin3 isn't targeted at end users, but at admins and developers. Sorry Andreas, I was thinking this would be for admins and developers, not end users. :) For unix, you can simply copy .pgadmin3 in the home directory, for win32 it's the KEY_CURRENT_USER\SOFTWARE\pgAdmin III registry branch. Sure, but that's a pain if you move between unix and win32 a lot, and/or have a bunch of admin's. I'm thinking of functionality that'll make administration of PG better in larger environments. Having a central repository makes a nice "foundation point" for building further functionality onto. For example, with a centalised repository we could have some kind of (SNMP?) daemon that keeps the repository updated with the status of the databases. If pgAdmin could also hook into this kind of repository, it could leverage off of the information there. Definitions of servers and databases, database status info (i.e. SNMP daemon as mentioned), perhaps replication status, and that kind of thing. Do you see where I'm trying to go with this? :-) Regards and best wishes, Justin Clift Regards, Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] Storing configuration in a centralised database?
Andreas Pflug wrote: You certainly can contribute something like that, it could accompany the "local server detection" stuff for win32. Show the code! I just wish pgAdmin was written in PHP-GTK. :) + Justin Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-support] Small bug when updating server info
Hi guys, Just found a small bug in pgAdmin3 (2nd November snapshot on Win32). When there is a bunch of existing server definitions, and I right click one, then choose "Properties" it lets me edit the properties. In the bug I found, if the existing definition has the SSL option set to "require" and I change it to some else (i.e. "allow" or the blank one), then that doesn't get saved. Every time I start pgAdmin, I have to change the definition again before using it. Bit of a pain. ;) (Sure, I could just delete and re-create it, but I haven't yet). Some of the other options are saved (i.e. username), but I haven't rigourouly gone through and changed them all. Thought it worth mentioning. Regards and best wishes, Justin Clift -- Executive Director Digital Distribution Global Training Services Pty. Ltd. Premier OpenOffice.org and StarOffice Online Training providers http://www.digitaldistribution.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
