> -----Original Message-----
> From: Bryan Bateman [mailto:batemanb@home.com]
> Sent: 28 November 2000 07:59
> To: pgsql-interfaces@postgresql.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.