Horton

Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page

Bruce Momjian <maillist@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: luuk_de_boer@pi.net (Luuk de Boer)
Cc: lockhart@alumni.caltech.edu, hackers@postgresql.org
Date: 1998-03-18T15:09:30Z
Lists: pgsql-hackers 
> 
> On 17 Mar 98 at 20:13, Bruce Momjian wrote:
> 
> > What does it mean when MySQL says "Ignored" in the CREATE INDEX entry?
> > 
> 
> mysql isn't supporting create index like the ansi sql way. You must 
> create an index in the create of the table with mysql. It's accepting 
> create index statements but it isn't doing anything with it so that's 
> why it's ignored.

So you can only have one index on a table?  Yikes.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)