Postgres Pro
Downloads
Home   >   mailing lists

Thread: old product version number

old product version number

From
Joel Stevenson
Date:
I'm new to the list, so hello everybody.

Can anybody tell me why the DatabaseMetaData
getDatabaseProductVersion () method is returning 6.5.2 when I'm
running version 7.1?  The getDriverVersion correctly returns 7.0.
Can't find anything in the docs or archives.

  Thanks.
--
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Joel Stevenson
Senior Human Interface Engineer
Bear River Associates, Inc.
(510) 834-5300 ext. 122

Re: old product version number

From
"Thomas O'Dowd"
Date:
On Fri, Jun 22, 2001 at 11:29:15AM -0700, Joel Stevenson wrote:
> I'm new to the list, so hello everybody.
>
> Can anybody tell me why the DatabaseMetaData
> getDatabaseProductVersion () method is returning 6.5.2 when I'm
> running version 7.1?  The getDriverVersion correctly returns 7.0.
> Can't find anything in the docs or archives.

the source for that function executes the code "select version()".
What do you get when you psql into you database and execute this?

Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
tom@nooper.com - Testing - http://nooper.co.jp/labs

Re: old product version number

From
Joel Stevenson
Date:

>On Fri, Jun 22, 2001 at 11:29:15AM -0700, Joel Stevenson wrote:
>>  I'm new to the list, so hello everybody.
>>
>>  Can anybody tell me why the DatabaseMetaData
>>  getDatabaseProductVersion () method is returning 6.5.2 when I'm
>>  running version 7.1?  The getDriverVersion correctly returns 7.0.
>>  Can't find anything in the docs or archives.
>
>the source for that function executes the code "select version()".
>What do you get when you psql into you database and execute this?

from psql:
testdb=> select version();
                           version
-----------------------------------------------------------
  PostgreSQL 7.1 on i586-pc-linux-gnu, compiled by GCC 2.96
(1 row)


>Tom.
>--
>Thomas O'Dowd. - Nooping - http://nooper.com
>tom@nooper.com - Testing - http://nooper.co.jp/labs

Re: old product version number

From
Joel Stevenson
Date:
Looks like that change from 1.9 to 1.10 would do it!  Thanks.

At 1:31 AM +0900 6/30/01, Thomas O'Dowd wrote:
>Hmmm, it is likely that you are using an old driver... See the
>diffs at...
>

>http://www.ca.postgresql.org/cgi/cvsweb.cgi/pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java.diff?r1=1.9&r2=1.10
>
>Looks like it used to return the version number of the driver... The current
>cvs driver works quite well and I imagine has fixed a number of problems
>since then.
>
>Tom.
>
>On Fri, Jun 29, 2001 at 08:54:35AM -0700, Joel Stevenson wrote:
>>
>>  >On Fri, Jun 22, 2001 at 11:29:15AM -0700, Joel Stevenson wrote:
>>  >>  I'm new to the list, so hello everybody.
>>  >>
>>  >>  Can anybody tell me why the DatabaseMetaData
>>  >>  getDatabaseProductVersion () method is returning 6.5.2 when I'm
>>  >>  running version 7.1?  The getDriverVersion correctly returns 7.0.
>>  >>  Can't find anything in the docs or archives.
>>  >
>>  >the source for that function executes the code "select version()".
>>  >What do you get when you psql into you database and execute this?
>>
>>  from psql:
>>  testdb=> select version();
>>                             version
>>  -----------------------------------------------------------
>>    PostgreSQL 7.1 on i586-pc-linux-gnu, compiled by GCC 2.96
>>  (1 row)
>>
>>
>>  >Tom.
>>  >--
>>  >Thomas O'Dowd. - Nooping - http://nooper.com
>>  >tom@nooper.com - Testing - http://nooper.co.jp/labs
>>
>
>--
>Thomas O'Dowd. - Nooping - http://nooper.com
>tom@nooper.com - Testing - http://nooper.co.jp/labs

Re: old product version number

From
"Thomas O'Dowd"
Date:
Hmmm, it is likely that you are using an old driver... See the
diffs at...


http://www.ca.postgresql.org/cgi/cvsweb.cgi/pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java.diff?r1=1.9&r2=1.10

Looks like it used to return the version number of the driver... The current
cvs driver works quite well and I imagine has fixed a number of problems
since then.

Tom.

On Fri, Jun 29, 2001 at 08:54:35AM -0700, Joel Stevenson wrote:
>
> >On Fri, Jun 22, 2001 at 11:29:15AM -0700, Joel Stevenson wrote:
> >>  I'm new to the list, so hello everybody.
> >>
> >>  Can anybody tell me why the DatabaseMetaData
> >>  getDatabaseProductVersion () method is returning 6.5.2 when I'm
> >>  running version 7.1?  The getDriverVersion correctly returns 7.0.
> >>  Can't find anything in the docs or archives.
> >
> >the source for that function executes the code "select version()".
> >What do you get when you psql into you database and execute this?
>
> from psql:
> testdb=> select version();
>                            version
> -----------------------------------------------------------
>   PostgreSQL 7.1 on i586-pc-linux-gnu, compiled by GCC 2.96
> (1 row)
>
>
> >Tom.
> >--
> >Thomas O'Dowd. - Nooping - http://nooper.com
> >tom@nooper.com - Testing - http://nooper.co.jp/labs
>

--
Thomas O'Dowd. - Nooping - http://nooper.com
tom@nooper.com - Testing - http://nooper.co.jp/labs