Received: from p3E9D3E1E.dip0.t-ipconnect.de (p3E9D3E1E.dip0.t-ipconnect.de [62.157.62.30]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA87866 for ; Mon, 3 Jan 2000 05:59:13 -0500 (EST) (envelope-from michael@fam-meskes.de) Received: (from michael@localhost) by p3E9D3E1E.dip0.t-ipconnect.de (8.9.3/8.9.3/Debian 8.9.3-6) id LAA01648 for pgsql-interfaces@postgresql.org; Mon, 3 Jan 2000 11:57:11 +0100 Date: Mon, 3 Jan 2000 11:57:10 +0100 From: Michael Meskes To: "'pgsql-interfaces@postgresql.org'" Subject: Re: [INTERFACES] still cannot connect with pgAdmin Message-ID: <20000103115710.F1357@fam-meskes.de> Mail-Followup-To: "'pgsql-interfaces@postgresql.org'" Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i On Sun, Jan 02, 2000 at 09:53:12AM -0000, Dave Page wrote: > SELECT version() > > 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=> Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!