[pgadmin-support] pgAdmin Beta 3 problems
I seem to have encountered several problems with the latest Beta3 of pgAdmin. This was installed with the latest Beta3 Dev1 installer for PostgreSQL. I had Beta2 of pgAdmin previously installed, which was uninstalled when I uninstalled Beta2 PostgreSQL. 1) The "Recent Files" menu doesn't seem to work at all any more. There was a list of files left over from a previous pgAdmin install. None of these worked. Even when opening a file then going to the recent files list it still wouldn't re-open. 2) Creating a new database on the local (Windows XP) cluster gave a "Locale: is invalid" message. I only typed in the name of the database and clicked OK. The default locale in the drop-down was UNICODE. When I selected something other than UNICODE and the re-selected UNICODE, clicked OK and it created the database OK. 3) It still gets the "dirty edit buffer" logic wrong. I have noticed that then I open a file it has not marked the buffer as dirty. I can navigate around the screen, making no changes and it is still OK. As soon as the edit buffer scrolls, with either the keyboard or mouse, the buffer is flagged as dirty and you are asked for saving changes when you quit. Regards, Gary. ---(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 III v1.2 Beta-3: Problem with "alter
On 27 Oct 2004 at 13:48, Andreas Pflug wrote: > Walter Haslbeck wrote: > > Andreas Pflug schrieb: > > > >> Still can't see any wrong behaviour, esp. no additional false line. > >> Please try the 20041022 snapshot, so we're on the very same lib versions. > > > > > > I allready tried the 20041022 snapshot, with the same (buggy) result.. > > > > But: with pgAdminII 1.2 beta2 everything works OK! > > Anybody else around here who can reproduce this? I can't see changes in > cvs that might have caused this, all related changes are pre-beta-1. > > Regards, > Andreas I can't reproduce the exact bug described, but there is some pretty strange behaviour. Unless I am using it wrong. If I click in the list of users/goups at the top of the dialog, the dropdown list below changes to reflect the selection and all works OK. If I change the dropdown, the listbox above is not changed to reflect the selection so I don't know what I am changing, the one in the top list or the one in the dropdown combo. If you type "public " (without quotes, note the space after public) you will get a new line for public This could get very confusing. It's possible that some combination of unsynchonised behaviour that we can't reproduce could result in Walter's problem, but it's a bit obscure. Cheers, Gary. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] pgAdmin III v1.2 Beta-3: Problem with "alter
On 27 Oct 2004 at 18:05, Andreas Pflug wrote: > > I suspect there's *something* he didn't tell us so far, since he's > experiencing this on more than one system. Can't imagine what... > Hmm, I can reproduce it, but *only* if I blank out the contents of the combo after clicking the public entry in the list above. I can't see any "accidental" way of blanking out the combo though. It probably didn't ought to allow a blank user! Cheers, Gary. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[pgadmin-support] Database /properties/variables problem.
Trying to set variables of a database using PGAdmin 3 (Windows, latest beta snapshot). I connect to the Windows (beta 4) server select a database, right click, select properties, variables tab. The Variable Name dropdown doesn't seem to work at all. Try to select other variables and nothing happens. Somehow I can occasionally select another variable name, but then the variable type etc. is completely out of sync. (e.g I can set the "default_statistics_target" to on or off!!) Cheers, Gary. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] Database /properties/variables problem.
Andreas Pflug wrote: Gary Doades wrote: Trying to set variables of a database using PGAdmin 3 (Windows, latest beta snapshot). I connect to the Windows (beta 4) server select a database, right click, select properties, variables tab. We had a combobox fix in RC1 for win32 (which in turn corrupted our GTK code...), try that. Regards, Andreas Err well.. the program works just fine thanks. The combo boxes now seem OK in RC1. But the installer seems a bit screwy. I tried to install RC1 over the beta version that installed with PostgreSQL beta4 installer. It left the old one in there. I removed all traces of the pgadmin beta and tried to re-install. Target was "C:\Program Files\PostgreSQL\8.0.0-beta4\pgadmin III\". The installer just put pg_dump and pg_restore in there! Uninstalled, re-installed with the default folder, same problem. Searched for pgadmin3.exe and it (and the rest of the files/folders) were on D:\. What happened Apart from fixing that it might be much less confusing to come to some agreement on where to install pgadmin. The PosgreSQL Windows installer and the pgadmin installer put it in different places. Cheers, Gary. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] pgAdmin III v1.2 RC?
Andreas Pflug wrote: Diego A. Gil wrote: Andreas: Can't we get a estimated column size from column metadata ?. Not too helpful in many cases I'm afraid. The text type is widely used What many other client tools of this type have is a "max column display size" setting. Often with a default of something like 30 chars. If the column size is less than this then use the column size otherwise use the maximum. This seems to work well for most data and would still be reasonable for text columns. Cheers, Gary. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-support] pgAdmin 1.2.0 rc1 win32 installer bug?
Mikko Korkalo wrote: Hi, I believe the win32 installer in this file: pgadmin3-1_2_0-rc1.zip is broken. If I choose to install to C:\Program Files\pgAdmin III\ , it is being installed to D:\. (pgAdmin.exe, docs and ui-directory appear in D:\) Can anyone confirm this? I'm running Windows XP SP2. regards, Mikko Korkalo This has been mentioned as a known, and recently fixed problem. It is in CVS, but not as a new installer yet. Cheers, Gary. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-support] Alter table not correct for Postgres 8.0+
If I try to add a column that is not null with a default the SQL that gets generated is: ALTER TABLE control ADD COLUMN security_options int; ALTER TABLE control ALTER COLUMN security_options SET NOT NULL; ALTER TABLE control ALTER COLUMN security_options SET DEFAULT 32; This generates an error if the table already contains rows. Whereas from 8.0 the following will work and ought to be used instead: ALTER TABLE control ADD COLUMN security_options int not null default 32; Thanks, Gary. ---(end of broadcast)--- TIP 8: explain analyze is your friend
