Hello everybody

I have to work with postgresql, but I don't know which stable version using:

the technical definition environnement is :
- development on windows 200 pro (I saw cygwin and v7.42 or v7.4.3 are
available)
- server on redhat ent v3 ( postgresql installed is in v7.3.6-1)
- application server : orion (java) (for tests) + php test (php4)
- pgadmin III and phpPgAdmin

I need to do interface with web application I have to developp in order to
use postgis too.

Could you give me advice about a stable version working with a jdbc driver,
accepted by postgis and suporting large objects ?
More thanks in advance

I use rpms to install on redhat


mpaule

-------------------------------------------------------------------------------------------
TORRE MPaule
Observatoire Oceanologique -OOV
PROOF Base de Données/Web
Quai de la Darse, BP8,Cas. Nicolas
06238 VILLEFRANCHE sur MER
FRANCE
TEL (33)4.93.76.38.77
FAX (33)4.93.76.38.73


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Wed, 2004-08-11 at 02:38, MP TORRE wrote:
I'd run 7.4.x (latest version) if it was up to me. 7.3.x is the oldest
version I'd consider putting into production on a new product, and only
if there was some issue running some tool I had against 7.4.

jdbc works pretty well in 7.4, as does postgis. all versions going
pretty far back support large objects, but I'm not a fan of large
objects, preferring to store binary things in the file system.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match