On Donnerstag, 13. März 2008, Scott Marlowe wrote: | My real complaint with InnoDB is it's a red headed step child. If | mysql supported only innodb, it would be a very different database, | and probably a bit simpler as well. no need to worry about how you | state fk-pk relationships (currently column level references are | silently dropped for innodb OR myisam). If there was a run time | switch that said "use only innodb and use syntax that's sane" I'd | probably be willing to test that out.
To be fair, MySQL-5 has such a switch (kind of): http://dev.mysql.com/doc/refman/5.0/en/faqs-sql-modes.html You can set the @@sql_mode variable to a value, that MySQL almost behaves like standard SQL (I've not tested this by myself, though). Ciao, Thomas -- Thomas Pundt <[EMAIL PROTECTED]> ---- http://rp-online.de/ ---- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
