From: Ian Barwick <barwick@gmx.net>
To: Lee Kindness <lkindness@csl.co.uk>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: [INTERFACES] Patch for DBD::Pg pg_relcheck problem
Date: Tue, 10 Dec 2002 17:35:47 +0100
Message-ID: <200212101735.47825.barwick@gmx.net> (raw)
In-Reply-To: <15862.3615.266952.454641@kelvin.csl.co.uk>
References: <200212091631.00125.barwick@gmx.net>
<200212101638.03642.barwick@gmx.net>
<15862.3615.266952.454641@kelvin.csl.co.uk>
(no followup to dbi-dev@perl.org, getting a little OT there)
On Tuesday 10 December 2002 16:54, Lee Kindness wrote:
> Ian Barwick writes:
> > 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...
Sounds logical - I was evidently thinking in Perl ;-).
For reference pg_dump currently parses the SELECT version() string
into an integer thus:
7.2 70200
7.2.1 70201
7.3devel 70300
7.3rc1 70300
7.3.1 70301
7.3.99 70399
7.399.399 110299
101.10.2 1011002
(and just for fun:
"11i Enterprise Edition with Bells and Whistles "
returns -1 ;-)
which works with minor release numbers of 99
and below.
Ian Barwick
barwick@gmx.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: barwick@gmx.net, lkindness@csl.co.uk, tgl@sss.pgh.pa.us, pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Patch for DBD::Pg pg_relcheck problem
In-Reply-To: <200212101735.47825.barwick@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox