From the technial point of view I have no idea of Postgres, so I can not comment on it. From the political view, I'd say supporting Postgres 7.4 only is OK. The MySQL port supports the latest version 4.0 and then the upcomig 4.1 only. So, it's the same there.
I do not suppose Postgres has big installations like Oracle, DB2 or MSSQLServer, has it? Supporting only the lastest version of those would be problematic as some companies really are tied to the specific version they happen to have installed - which rarely is the most recent one.
Cheers,
Oliver
P.S.: Looking forward to this Postgres port, a colleague of mine is a fan of Postgres and has already installed it for me :)
Martin Holz wrote:
Hello,
when adapting the RDBMSAdapter to Postgres 7.3, I run into serious trouble, so I would prefer to support only Postgres 7.4. Does anybody need support for older Postgres versions?
Problem with Postgres 7.2 and 7.3 is the content. There are two ways to store large binary data in Postgres, the bytea datatype and LargeObjects.
Access to bytea using jdbc is very memory consuming for
Postgres 7.3. Its unusable for data larger than approximately
4 MByte. This was a problem of the client/server protocol, which is fixed in 7.4.
LargeObject works for much larger data. I tested it using files up to 100 MB. However it requires access to the
LargeObject extensions of the JDBCDriver. Those are only available, if you cast the java.sql.Connection to a org.postgresql.PGConnection. But this is problematic,
if you access the database through a connection pool.
IIRC you could get a handle to the underlying connection
in commons-dbcp, but that's a hack.
I never used Postgres 6.x, but you glimpse into the mail archives makes me fear, things are even worse there.
So I would prefer to support only Postgres 7.4 and use the bytea datatype.
WDYT?
Martin
-- Martin Holz <[EMAIL PROTECTED]>
Softwareentwicklung / Vernetztes Studium - Chemie
FIZ CHEMIE Berlin
Franklinstrasse 11
D-10587 Berlin
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
