Re: Strange behaviour of JDBC driver for PostgreSQL

From: Carlos Correia <carlos(at)m16e(dot)com>
To: "Thomas O'Dowd" <tom(at)nooper(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, Dave(at)micro-automation(dot)net
Subject: Re: Strange behaviour of JDBC driver for PostgreSQL
Date: 2002-12-19 11:20:58
Message-ID: 3E01AB9A.9060801@m16e.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I've been working with Linux and Java for more then 4 years, so I'm sure
of what I'm saying: never had or used such a version!

Anyway, here's the output from:

$ psql -h REMOTEHOSTNAME -U USERNAME -c 'SELECT version();' DBNAME


version
----------------------------------------------------------------------------------------------------
PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
(Mandrake Linux 9.0 3.2-1mdk)
(1 row)

Best Regards,

Carlos

Thomas O'Dowd wrote:

>Carlos,
>
>To satisfy everyones curiosity why don't you try sending us the output
>of the following command from your local machine...
>
>$ psql -h REMOTEHOSTNAME -U USERNAME -c 'SELECT version();' DBNAME
>
>This will access the remote database DBNAME in much the same way as the
>driver does.
>
>Tom.
>
>On Thu, 2002-12-19 at 02:55, Carlos Correia wrote:
>
>
>>Fernando,
>>
>>i am sure the db is version 7.2.2
>>
>>Thanks anyway,
>>
>>Carlos
>>
>>Fernando Nasser wrote:
>>
>>
>>
>>>Carlos Correia wrote:
>>>
>>>
>>>
>>>>Dave Cramer wrote:
>>>>
>>>>
>>>>
>>>>>Carlos,
>>>>>
>>>>>Is this a new message today, or one from yesterday?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>Dave,
>>>>
>>>>It is the same messge, but as I think that everyone is
>>>>misunderstooding the problem, I'll try to resume it:
>>>>
>>>>1. I don't know why the driver reports version 6.5.2, as I don't have
>>>>such a version.
>>>>
>>>>
>>>The JDBC driver receives the version from the database backend when
>>>connecting and that is what is printed by the
>>>getDatabaseProductVersion() function. There is no way it can generate
>>>a 6.x.x version number by itself.
>>>
>>>You _must_ be connecting to a 6.5.2 backend.
>>>
>>>
>>>
>>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>
>>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-12-19 11:37:17 Re: error when using move, any suggestions?
Previous Message Andreas Joseph Krogh 2002-12-19 10:01:25 Re: Schema in connection URL