Re: Error while executing the query; ERROR: At

> -----Original Message-----
> From: Andrès de Barros [mailto:adebarros(at)multitel(dot)com(dot)uy]
> Sent: 19 September 2001 23:06
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Error while executing the query;
> ERROR: Attribute 'datlastsysoid' not found
>
>
> Mr. of PgAdmin I am having problems with the connection from
> Windows with pgAdmin II V1.1 against a Linux RedHat 7,0 with
> PostGreSQL V 7.0.2. I am trying to connect me to the server
> and reports the following message
>
> "19/09/2001 19:01:17 - SQL (template1): SELECT version(),
> datlastsysoid FROM pg_database WHERE datname = 'template1'
> 19/09/2001 19:01:17 - Error in pgAdmin
> II:frmConnect.cmdConnect_Click: -2147467259 - Error while
> executing the query; ERROR: Attribute 'datlastsysoid' not found"
>
> I hope to have some answer to this problem.
> Greetings Andrés de Barros Multitel Uruguay

Hi,

This problem occurs because you are using PostgreSQL 7.0.x which doesn't
have the datlastsysoid column in pg_database. pgAdmin II is designed for
PostgreSQL 7.1 or higher so you will need to upgrade PostgreSQL I'm afraid
(this isn't really a bad thing, there have been lots of new features and bug
fixes since then).

Regards, Dave.