> Is anyone looking at doing this? Is this purely a MySQL-ism, or is it
> something that everyone else has except us?
We should not only support access to all db's under one postmaster,
but also remote access to other postmaster's databases.
All biggie db's allow this in one way or another (synonyms,
qualified object names) including 2-phase commit.
Ideally this includes access to other db manufacturers, flat files, bdb ...
Meaning, that this is a problem needing a generic approach.
Andreas
> > > Is there any possibility to get a port for MySQL with BerkleyDB support?
> > > I realy need the transaction support and I'd like to build MySQL from a
> > > port.
> >
> > why not just build PgSQL, and have transaction support *with* subselects
> > and everything else that mySQL doesn't have?
>
> I'd *love* to use PgSQL, but it doesn't support cross-DB joins (or at
> least I couldn't figure out how to do it.) MySQL handles this, so
> I'm using MySQL and would also like to have transaction support...