RE: pgAdmin problems

> -----Original Message-----
> From: Bryan Bateman [mailto:batemanb(at)home(dot)com]
> Sent: 28 November 2000 07:59
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] pgAdmin problems
>
>
> I have sucessfully installed postgres on a Linux machine. I can us
> phpPgAdmin running under Apache on the linux machine to manipulate the
> database. I have created a DSN on a Win2K box and can link
> through it to
> the database on the linux box.
>
> I then start up PgAdmin to connect through the same DSN and get the
> following error in the log file:

<SNIP>

This error is caused by records being missing from the pgadmin_param system
table. It should self-repair itself, however in some circumstances it may
not. To fix it manually (assuming you don't use revision tracking - if so,
please let me know your current version number) execute the following SQL
queries in an SQL dialogue:

DELETE FROM pgadmin_param
INSERT INTO pgadmin_param VALUES ('1', '1', 'SSO Version')
INSERT INTO pgadmin_param VALUES(2, 'N', 'Revision Tracking enabled?')
INSERT INTO pgadmin_param VALUES(3, '1.0', 'Revision Tracking version')

This bug has been fixed in the current development code.

Regards,
Dave.