Re: Error while executing the query; ERROR: At

[Dave Page]

> -----Original Message-----
> From: Andrès de Barros [mailto:[EMAIL PROTECTED]] 
> Sent: 19 September 2001 23:06
> To: [EMAIL PROTECTED]
> 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.