Skip site navigation (1) Skip section navigation (2)

Re: Startup message issues

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Chris Smith <cdsmith(at)twu(dot)net>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Startup message issues
Date: 2004-02-13 18:59:10
Message-ID: 1076698750.6802.50.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
Chris,

that is true, at least the first bit. If we successfully connect with V3
then we are talking to at least a 7.4 backend, however the driver does
need to be able to talk to a 7.3 backend, so some of the compatibility
stuff needs to stay.


Dave
On Fri, 2004-02-13 at 12:46, Chris Smith wrote:
> Hope you don't mind the sudden questions.
> 
> I'm working through the JDBC driver code.  The connection code really confuses
> me.  It seems like if we're speaking the V3 protocol successfully, we ought to
> be able to assume that the server is at least 7.4.  That would seem to remove
> a lot of the complexity of the open-connection code for v3 - namely, the
> client encoding stuff that contains backward-compatibility code all the way
> back to 7.1, and the 'show autocommit' that seems to have been an issue only
> for 7.3.  Assuming 7.4, I think we could jsut assume autocommit and set the
> client encoding to UNICODE in the startup message, and be done with it.
> Right?
> 
> (Note: I don't actually know anything about the actual defaults and concerns
> here.  I'm getting my information from other code in the driver that makes
> these same assumptions that I'm proposing to make here.  If one of these
> assumptions is wrong, then it's the other code that needs to be fixed.)
> 
> Comments?
> 
> --
> www.designacourse.com
> The Easiest Way to Train Anyone... Anywhere.
> 
> Chris Smith - Lead Software Developer/Technical Trainer
> MindIQ Corporation
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561


In response to

pgsql-jdbc by date

Next:From: Chris SmithDate: 2004-02-13 21:24:19
Subject: Unit tests
Previous:From: Chris SmithDate: 2004-02-13 18:56:42
Subject: Fw: PATCH (Re: Startup message issues)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group