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
