Thread: 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.

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

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.

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Gary Doades
> Sent: 09 November 2004 19:34
> To: Andreas Pflug
> Cc: Pgadmin Support
> Subject: Re: [pgadmin-support] Database /properties/variables problem.
>
>
> 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????

Sorry, my fault. It's fixed in CVS now.

> 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.

The PostgreSQL installer supports multiple versions being intstalled at
once, and installs everything under it's own version-specific directory.
pgAdmin doesn't have such support, and even if it did, wouldn't tie in
with the PostgreSQL versions.

You can always select to install pgAdmin in a different place in either
installer.

Regards, Dave