Re: Using 7.1 driver with 7.3?

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: Mike Bridge <mike(at)bridgecanada(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Using 7.1 driver with 7.3?
Date: 2002-12-24 01:50:12
Message-ID: 1040694612.31645.177.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Mike,

Yes, you need to add "with time zone" to the timestamp declaration

Dave
On Mon, 2002-12-23 at 20:37, Mike Bridge wrote:
> Thanks to everyone who responded. It sounds like it's better
> to do this the proper way and wait for a vendor fix rather
> than try to push ahead and muddle through with a mismatched
> driver.
>
> I did try out the timestamp(0) solution, and that appears to
> work, although I note that there is a slight format difference
> (no timezone) when I do a "select now()", which makes me think
> that there are probably other subtle differences lurking about.
>
> Thanks!
>
> -Mike
>
>
>
>
> On Mon, Dec 23, 2002 at 02:52:31PM -0500, Dave Cramer wrote:
> > Mike,
> >
> > I would have to concur with tom here, the driver has gone through
> > extensive reworking since 7.1. On top of that, you are painting yourself
> > into a corner. You would be better to solve your problems now. Future
> > servers will not be compatible with 7.1 drivers
--
Dave Cramer <Dave(at)micro-automation(dot)net>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-12-24 16:04:00 [Fwd: Re: JDBC SSL - looking for test partners]
Previous Message Mike Bridge 2002-12-24 01:37:45 Re: Using 7.1 driver with 7.3?