Re: PostgreSQL 8.1 vs. MySQL 5.0?

No. Distributed transactions can cooperate in two phase commit.

I think someone has done some two phase commit work already. IIRC.

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of CSN
> Sent: Wednesday, October 05, 2005 11:11 PM
> To: jd(at)commandprompt(dot)com
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?
>
>
> I'm not sure what XA (distributed transactions) is -
> is that something that can be achieved with Slony?
>
> CSN
>
>
> --- "Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:
>
> > On Wed, 2005-10-05 at 18:37 -0700, CSN wrote:
> > > Just so I know (and am armed ;) ), are there any
> > new
> > > comparable features in MySQL 5.0 that aren't in
> > > PostgreSQL up to the forthcoming 8.1? AFAIK, PG
> > just
> > > lacks updatable views (which are on the TODO).
> > >
> > > MySQL 5.0 new features
> > >
> >
> http://dev.mysql.com/doc/mysql/en/mysql-5-0-nutshell.html
> >
> > Well "IF" they are being completely honest, we don't
> > have XA
> > and we don't have an "instance manager" but of
> > course who really needs
> > one?
> >
> > Sincerely,
> >
> > Joshua D. Drake
> >
> >
> > >
> > > Thanks,
> > > CSN
> > >
> > >
> > >
> > > __________________________________
> > > Yahoo! Mail - PC Magazine Editors' Choice 2005
> > > http://mail.yahoo.com
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 2: Don't 'kill -9' the postmaster
> > --
> > Your PostgreSQL solutions company - Command Prompt,
> > Inc. 1.800.492.2240
> > PostgreSQL Replication, Consulting, Custom
> > Programming, 24x7 support
> > Managed Services, Shared and Dedicated Hosting
> > Co-Authors: plPHP, plPerlNG -
> > http://www.commandprompt.com/
> >
> >
> >
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match