[pgadmin-support] Alter table not correct for Postgres 8.0+

2004-11-20 Thread Gary Doades
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 a

Re: [pgadmin-support] pgAdmin 1.2.0 rc1 win32 installer bug?

2004-11-14 Thread Gary Doades
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. rega

Re: [pgadmin-support] pgAdmin III v1.2 RC?

2004-11-10 Thread Gary Doades
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

Re: [pgadmin-support] Database /properties/variables problem.

2004-11-09 Thread Gary Doades
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

[pgadmin-support] Database /properties/variables problem.

2004-11-07 Thread Gary Doades
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 hap

Re: [pgadmin-support] pgAdmin III v1.2 Beta-3: Problem with "alter

2004-10-27 Thread Gary Doades
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 entr

Re: [pgadmin-support] pgAdmin III v1.2 Beta-3: Problem with "alter

2004-10-27 Thread Gary Doades
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

[pgadmin-support] pgAdmin Beta 3 problems

2004-10-21 Thread Gary Doades
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