> -----Original Message-----
> From: J. Ramirez [mailto:j.ramirez@elportaldeinternet.com]
> Sent: 22 August 2001 13:24
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] I need help
>
>
> Hello, this is the first time I write in this list and it´s
> because I can´t connect from a windows PC to a postgresql
> (6.5.3) server running under linux (Red Hat 6.2), the error
> message I receive from de pgadminII es: 22/08/01 14:04:01 -
> Closing cnPostgreSQL 22/08/01 14:04:01 - SQL (template1):
> SELECT version(), datlastsysoid FROM pg_database WHERE
> datname = 'template1' 22/08/01 14:04:01 - Error in pgAdmin
> II:frmConnect.cmdConnect_Click: -2147467259 - Error while
> executing the query; ERROR: attribute 'datlastsysoid' not
> found From the same PC I can connect using Microsoft Access
> and Linking tables using a ODBC driver that I have added to
> the ODBC 'data sources' with the same propierties I use in pgadmin II.
Hi,
pgAdmin II was developed with PostgreSQL 7.1.X which has a 'datlastsysoid'
column in pg_database. This isn't in PostgreSQL 6.5 and hence the error
occur. Unfortunately I don't have the time to ensure pgAdmin runs with
earlier versions of PostgreSQL (though in the future, I will try to maintain
backwards compatibility with versions we previously supported).
I would strongly suggest upgrading to PostgreSQL 7.1.3 - there have been a
huge amount of bug fixes and new features since 6.5.3. And of course,
pgAdmin II will work :-).
Regards Dave.
