Skip site navigation (1) Skip section navigation (2)

RE: I need help

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'J(dot) Ramirez'" <j(dot)ramirez(at)elportaldeinternet(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: RE: I need help
Date: 2001-08-22 19:45:07
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2DBF@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: J. Ramirez [mailto:j(dot)ramirez(at)elportaldeinternet(dot)com] 
> Sent: 22 August 2001 13:24
> To: pgadmin-support(at)postgresql(dot)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.

Responses

pgadmin-support by date

Next:From: J. RamirezDate: 2001-08-23 08:49:15
Subject: RE: I need help
Previous:From: J. RamirezDate: 2001-08-22 12:23:30
Subject: I need help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group