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@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of CSN > Sent: Wednesday, October 05, 2005 11:11 PM > To: jd@xxxxxxxxxxxxxxxxx > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
