Re: [INTERFACES] still cannot connect with pgAdmin

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Meskes <meskes(at)postgreSQL(dot)org>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] still cannot connect with pgAdmin
Date: 2000-01-03 15:12:14
Message-ID: 8137.946912334@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Michael Meskes <meskes(at)postgreSQL(dot)org> writes:
> On Sun, Jan 02, 2000 at 09:53:12AM -0000, Dave Page wrote:
>> To work correctly, the major and minor version numbers of the database
>> should be the same as pgAdmin's (eg. 6.5.x PostgreSQL will work with 6.5.x
>> pgAdmin). In the case of pgAdmin 6.5.x, it is looking at the first 14
>> characters returned by the SELECT which are expected to be:
>>
>> PostgreSQL 6.5
>>
>> If they are not, then you get the error you've experienced.

> But checking with psql I get
> timesheet=> select version();
> version
> -------------------------------------------------------------
> PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2
> (1 row)
> timesheet=>

Before you spend too much time digging for a bug in pgAdmin,
check the possibility that it's connecting to some other database
server than you think it is. Just a thought...

regards, tom lane

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jeffrey Lyon 2000-01-03 19:30:06
Previous Message Tusar 2000-01-03 11:28:22 Re: [INTERFACES] Announce: PostgreSQL-6.5.3 binaries available for Windows NT