Hans, I don't understand the statement about missing "DECLARE CURSOR" ? The backend supports it?
Dave On Sun, 2003-11-23 at 12:12, Hans-Jürgen Schönig wrote: > Peter Eisentraut wrote: > > I was at the ObjectWeb Conference today; ObjectWeb > > (http://www.objectweb.org) being a consortium that has amassed quite an > > impressive array of open-source, Java-based middleware under their > > umbrella, including for instance our old friend Enhydra. And they > > regularly kept mentioning PostgreSQL in their presentations. > > > > To those that are interested in distributed transactions/two-phase commit, > > I recommend taking a look at Clustered JDBC > > (http://c-jdbc.objectweb.org/). While this is not exactly the same thing, > > it looks to be a pretty neat solution for a similar class of applications. > > In particular, it provides redundancy, load balancing, caching, and even > > database independence. > > > > > It is indeed a nice solution but it is far from ready yet. > Especially the disaster recovery mechanism and things such as adding new > masters need some more work. > What I really miss is "DECLARE CURSOR". Maybe it will be in there some > day :). > However, we have done some real testing with sync replication (4 x pg, 1 > x oracle). It performed surprisingly well (the JDBC part, not the Oracle > one ;) ). > Maybe this will be something really useful within the next few months. > > Cheers, > > Hans ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
