Thread: Log in

I can't log in to database.
In log file is:
25.9.2001 10:31:45 - Connecting to 172.17.6.60...
25.9.2001 10:31:45 - Opening cnPostgreSQL:
DRIVER=PostgreSQL;SERVER=172.17.6.60;PORT=5432;UID=postgres;PWD=********;DAT
ABASE=template1
25.9.2001 10:31:45 - SQL (template1): SELECT version(), datlastsysoid FROM
pg_database WHERE datname = 'template1'
25.9.2001 10:31:45 - Done - 0,16 Secs.
25.9.2001 10:31:45 - Error in pgAdmin II:frmConnect.cmdConnect_Click:
-2147467259 - Error while executing the query; ERROR:  Attribute
'datlastsysoid' not found

I use pgAdminII on Win2K, and PostgreSQL on SuSE 7.2. PostgreSQL work
proprly and I can use it through Webmin or terminal.

ooooooooooooooooooooooooooooooooooooooo
o BOŠTJAN KOLBEZEN - broadcast engineer
o bostjan.kolbezen@rtvslo.si
o Radiotelevizija Slovenija
o TV Production
o Slovenija, 1550 Ljubljana
o Kolodvorska 2

> -----Original Message-----
> From: Bostjan Kolbezen [mailto:Bostjan.Kolbezen@rtvslo.si]
> Sent: 25 September 2001 09:42
> To: 'pgadmin-support@postgresql.org'
> Subject: [pgadmin-support] Log in
>
>
> I can't log in to database.
> In log file is:
> 25.9.2001 10:31:45 - Connecting to 172.17.6.60...
> 25.9.2001 10:31:45 - Opening cnPostgreSQL:
> DRIVER=PostgreSQL;SERVER=172.17.6.60;PORT=5432;UID=postgres;PW
> D=********;DAT
> ABASE=template1
> 25.9.2001 10:31:45 - SQL (template1): SELECT version(),
> datlastsysoid FROM pg_database WHERE datname = 'template1'
> 25.9.2001 10:31:45 - Done - 0,16 Secs. 25.9.2001 10:31:45 -
> Error in pgAdmin II:frmConnect.cmdConnect_Click: -2147467259
> - Error while executing the query; ERROR:  Attribute
> 'datlastsysoid' not found

This error occurs because you are using an old version of PostgreSQL.
pgAdmin II requires v7.1 or higher, so you will need to upgrade I'm afraid
(that's not a bad idea anyway, there have been quite a few bug fixes since
even 7.0.x).

I know it won't help you, :-(, but I have made this requirement more obvious
on the website now.

Regards, Dave.