Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 57EB3476434; Tue, 10 Dec 2002 10:55:27 -0500 (EST)
Received: from internet.csl.co.uk (internet.csl.co.uk [194.130.52.3])
	by postgresql.org (Postfix) with ESMTP
	id 94CFA4767F1; Tue, 10 Dec 2002 10:54:10 -0500 (EST)
Received: from euphrates.csl.co.uk (host-194-67.csl.co.uk [194.130.52.67])
	by internet.csl.co.uk (8.12.6/8.12.6) with ESMTP id gBAFs72E027683;
	Tue, 10 Dec 2002 15:54:07 GMT
Received: from kelvin.csl.co.uk by euphrates.csl.co.uk (8.9.3/ConceptI 2.4)
	id PAA14245; Tue, 10 Dec 2002 15:54:09 GMT
Received: by kelvin.csl.co.uk (8.11.6) id gBAFs7410972;
	Tue, 10 Dec 2002 15:54:07 GMT
From: Lee Kindness <lkindness@csl.co.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <15862.3615.266952.454641@kelvin.csl.co.uk>
Date: Tue, 10 Dec 2002 15:54:07 +0000
To: Ian Barwick <barwick@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, dbi-dev@perl.org,
	pgsql-interfaces@postgresql.org, pgsql-hackers@postgresql.org,
	Lee Kindness <lkindness@csl.co.uk>
Subject: Re: [INTERFACES] Patch for DBD::Pg pg_relcheck problem
In-Reply-To: <200212101638.03642.barwick@gmx.net>
References: <200212091631.00125.barwick@gmx.net>
	<200212100034.31936.barwick@gmx.net>
	<20819.1039477650@sss.pgh.pa.us>
	<200212101638.03642.barwick@gmx.net>
X-Mailer: VM 7.00 under 21.4 (patch 6) "Common Lisp" XEmacs Lucid
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/586
X-Sequence-Number: 33041

Ian Barwick writes:
 > On Tuesday 10 December 2002 00:47, Tom Lane wrote:
 > > In the next protocol version update (hopefully 7.4) I would like to see
 > > the basic version string (eg, "7.3.1" or "7.4devel") delivered to the
 > > client automatically during connection startup and then available from a
 > > libpq inquiry function.  This would eliminate the need to call version()
 > > explicitly and to know that you must skip "PostgreSQL " in its output.
 > Something along the lines of 
 >   char *PQversion(const PGconn *conn) ?

Probably:

 int PQversion(const PGconn *conn)

would be better, and easier to parse? For example the value returned
for 7.3.1 would be 7003001; for 7.4 7004000; for 101.10.2
101010002. This allows simple numerical tests...

Lee.