RE: What versions of Postgres are people using?
I'm using Postgresql 7.0.3 on RH7 with pleasant results (except the JDBC driver's timstamp issue). saw something on the postgres JDBC list about that - something about using getTimestamp instead of getDate or similar because getDate doesn't properly convert timestamp fields? Not sure if that's at all meaningful :-) (I missed the start of the timestamp discussion on the orion list) I don't serialize any objects as BLOBs though. Why do you want to do . this? surely that's what orion does by default with serialized data and CMP? (OK, not a blob but a large object / oid in Postgres, same sort of thing though). Certainly Orion died running against Postgres 703 with exactly the same error as my little binary-insert test utility did ("inputstream unsupported" or similar, which comes from PreparedStatement's setbinaryStream method). I'm actually using BMP for all the stuff I'm doing, but still need to insert chunks of data into the DB... cheers Jules
RE: What versions of Postgres are people using?
Title: RE: What versions of Postgres are people using? I've run 7.1 beta 3 with no problems. It is _much_ faster than 7.0.2 (2.5x on some rough benchmarks) and finally supports OUTER JOIN. I've never used blobs with it though so I cannot speak for that support. -tim -Original Message- From: Julian Richardson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 10:28 AM To: Orion-Interest Subject: What versions of Postgres are people using? Hi, Following on from my earlier questions about alternatives to Hypersonic, a few people recommended Postgres. Well, I'd been meaning to try Postgres generally for a long time anyway, so downloaded the latest version from the site (703) and installed it. Orion wouldn't run with it, complaining about lack of binary object support (fair enough given that looking inthe JDBC source reveals that it's not implemented in 703!). Thing is, I was talking to the guy who wrote the Postgres drivers and it sounds like there was no stream support in 6.5 either; this is new in 7.1 (which isn't released yet). But Orion must require the use of somthing like this to store serialized data, surely? So what are the people on the list who use Postgres actually using? Have you patched the JDBC drivers to work, or did someone release patched 6.5 drivers for Postgres which everyone's installed? Or have you modified Orion to serialize data using some other mechanism to the default? I imagine most people on the list are using 6.5 rather than 7.0.3? Confusing, to say the least... cheers Jules
RE: What versions of Postgres are people using?
I'm using Postgresql 7.0.3 on RH7 with pleasant results (except the JDBC driver's timstamp issue). I don't serialize any objects as BLOBs though. Why do you want to do this? Jeff -Original Message- From: Julian Richardson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 7:28 AM To: Orion-Interest Subject: What versions of Postgres are people using? Hi, Following on from my earlier questions about alternatives to Hypersonic, a few people recommended Postgres. Well, I'd been meaning to try Postgres generally for a long time anyway, so downloaded the latest version from the site (703) and installed it. Orion wouldn't run with it, complaining about lack of binary object support (fair enough given that looking inthe JDBC source reveals that it's not implemented in 703!). Thing is, I was talking to the guy who wrote the Postgres drivers and it sounds like there was no stream support in 6.5 either; this is new in 7.1 (which isn't released yet). But Orion must require the use of somthing like this to store serialized data, surely? So what are the people on the list who use Postgres actually using? Have you patched the JDBC drivers to work, or did someone release patched 6.5 drivers for Postgres which everyone's installed? Or have you modified Orion to serialize data using some other mechanism to the default? I imagine most people on the list are using 6.5 rather than 7.0.3? Confusing, to say the least... cheers Jules