Thread: Unable to connect

Unable to connect

From
Cédric Avena
Date:
I tried to connect to my databases (6.5.3 & 7.0.3), but pgAdminII
returned me:

A error has occured...
Number: -2147467259
Description: Error while executing the query ;
ERROR: Attribute 'datlastsysoid' not found

I installed v1.1 Build 20 and MDAC 2.6

What's wrong ?
--
Cédric Avena
WAW - Web At Work
http://www.waw.com mailto:cedric.avena@waw.com


RE: Unable to connect

From
Dave Page
Date:

> -----Original Message-----
> From: Cédric Avena [mailto:cedric.avena@waw.com]
> Sent: 20 August 2001 09:36
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Unable to connect
>
>
> I tried to connect to my databases (6.5.3 & 7.0.3), but
> pgAdminII returned me:
>
> A error has occured...
> Number: -2147467259
> Description: Error while executing the query ;
> ERROR: Attribute 'datlastsysoid' not found
>
> I installed v1.1 Build 20 and MDAC 2.6
>
> What's wrong ?

Hi Cédric,

'datlastsysoid' is a column in the pg_database system table. Unfortunately
it's only present in PostgreSQL 7.1 or higher. Unfortunately I can't really
devote the time to making the new code backward compatible with old versions
of PostgreSQL, so my best suggestion would be to upgrade to PostgreSQL 7.1.
To quote Tom Lane (one of the core PostgreSQL developers) from a message I
read this morning:

'It's *way* past time to update.  7.1.3 is current PG release, and the list
of bugs fixed since 6.5.* would fill a book.'

Regards, Dave.