Re: Re: [Fwd: JDBC Timestamp problem]

Peter T Mount wrote:

> Quoting Antonio Fiol <fiol(at)w3ping(dot)com>:
>
> > Joseph Shraibman wrote:
> >
> > > jdbc version don't follow postgres versions, so the jdbc drivers from
> > > the 7.1 codebase should work with a 7.0 server. Provided there
> > aren't any bugs in those jdbc drivers, of course. Why are you using 7.0
> > when 7.0.3 is out? I think some of the timestamp problems were fixed in
> > > 7.0.3.
>
> I can't guarantee that 7.1 will work with 7.0. 99% of it will do but some
> MetaData methods will not because they use features only present in 7.1 (ie
> inner/outer joins). What's in CVS will do, but I have those changes ready to
> commit.
>
> [Before anyone asks, these should throw an SQLException which is the correct
> way to handle this under the JDBC Spec ;-) ]
>
> In general the JDBC driver should work with at least the previous version, but
> it does try to stay inline with the current version (which is why I keep a
> binary copy of previous versions on the web site.
>
> > In fact, what I downloaded was the RedHat RPMs for 7.0.3-2.
>
> There were still Timestamp bugs in 7.0.3. Hopefully they are gone in 7.1

Is 7.1 stable enough for a production environment. In fact, I am changing from 6.5
to a newer version because 6.5 tends to break some tables (bits moved over the end
of the world, or something alike) and some indexes tend to become out of order.

Our environment has about 500 tables with 0.5K~2M tuples (about 1Gb of data, by
the moment) and data loss is critical.

> > > > > Yes, there's been a lot of problems with timestamps, mainly where
> > it was
> > > > > getting confused with timezone/millisecond variations. 99% of
> > these have been
> > > > > fixed in the 7.1 driver.
> > > > >
> > > > > (I say 99% as there is bound to be a senario we've missed out ;-)
> > )
> > > > >
> > > > > Peter
> > > >
> > > > I downloaded the 7.0 three days ago!!!!
> > > >
> > > > Is there an RPM for the 7.1 stuff?
> >
> > I reiterate my question: Are there RPM packages for the 7.1 driver? If
> > so, where can I find them?
>
> I'm not sure about the current 7.1beta's. However, I've not put up a 7.1 .jar
> file (all that's needed really) for the betas as things have been a bit fast of
> late. I'll put a current beta on the web site over the weekend.

Beta... I see... (previous question...)

> > Thank you all for your help! Your support is much better than that of
> > IBM DB2 or Oracle.
>
> I'm slowly discovering that our JDBC driver seems to support more JDBC than
> Oracle's does (or appears). I've been playing with Oracle8i since starting this
> job two months ago, and it's been amazing what we can do that it can't
> (Inner/Outer joins for a start) ;-)

Yes, and if you make a default install, and then create a database and try to
INSERT about 5K times then COMMIT, and you repeat this operation several times, it
crashes. Performance did not seem that better to me once this problem was solved,
etc...

I was REALLY SERIOUSLY considering to switch to a commercial product like Oracle
or DB2, but if I get good results by upgrading PostgreSQL, I will certainly keep
it. I might even try to convince my boss that a little logo of PostgreSQL on our
home page would not harm anybody...

Could you mail me with the URLs when you upload them? I will be happy to test it!!

Antonio Fiol

> Peter
>
> > Thanks again!
> >
> > Antonio Fiol
> >
> >
> > > > Should I install all of the 7.1 packages, or should the JDBC driver
> > be enough?
> > > >
> > > > If all of them are necessary, must I recreate my database, or can I
> > upgrade
> > > > cleanly, without touching to my data ?
> > > >
> > > > Thank you for answering that quickly !!!!
> > > >
> > > > Antonio Fiol
> > > > W3ping
> > >
> > > --
> > > Joseph Shraibman
> > > jks(at)selectacast(dot)net
> > > Increase signal to noise ratio. http://www.targabot.com
> >
> >
>
> --
> Peter Mount peter(at)retep(dot)org(dot)uk
> PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
> RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/