Peter T Mount wrote:
Quoting Antonio Fiol [EMAIL PROTECTED]:
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
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
--
Peter Mount [EMAIL PROTECTED]
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/