Foreign keys / Transactions in MySQL.. WTF?

[Adam Witney]

On 31/7/07 13:28, "Peter Corlett" <abuse at cabal.org.uk> wrote:

> On Tue, Jul 31, 2007 at 12:42:16PM +0100, Aaron Trevena wrote:
>> On 31/07/07, Peter Corlett <abuse at cabal.org.uk> wrote:
> [...]
>>> MySQL's alleged full-text support is a load of gash and no better than
>>> LIKE '%keyword%" (thus doing a full table scan) but you presumably knew
>>> that already.
>> It beats SQL Server and Postgres.
> 
> tsearch2. Look in the contrib directory.

And tsearch2 is planned to be integrated in the main source code in 8.3 (the
next version, due somewhere near the end of the year).