"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: > 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? We don't have XA built into the backend, but if I've been following the jdbc list accurately, there's fairly complete XA support for the jdbc driver, which should be available in the 8.1 release. More generally, it's worth making the point that a lot of MySQL's "brand new in 5.0" features have been in Postgres for a *long* time, and are therefore likely to be both more stable and better-performing than MySQL's first cut at them. (BTW, it sure seems like MySQL 5.0 has been a heckuva long time in getting to release status. Has anyone here been following that process? Why's it been so painful?) regards, tom lane ---------------------------(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
