Re: index already exists


"Dave Brown" wrote...

> I've got a number of table in a hsqldb, i.e DIVES, LOCATIONS
>
> My Locations table as a column called Location_ID which is its primary
> key. The DIVES table also has a column called Location_ID, so I know at
> which location the Dives was at.
>
> I want to create an index of the Location_ID in the dives table but when I
> do a "CREATE INDEX Location_ID on DIVES(Location_ID)"
>
> I get back an "index already exists" error, it definately is NOT an index
> in the DIVES table. This is confusing me completely. I'm using
> DBVIsualizer as a GUI to maintain my HSQLDB tables.
>
> Can anyone shed any light on why I'm getting this message back ?

So what is the name of the index of Location_ID on LOCATIONS?

Probably Location_ID, isn't it?

I suggest you simply try:

"CREATE INDEX Dives_Location_ID on DIVES(Location_ID)"

i.e. give the index a different name than the existing one...

// Bjorn A



.

Relevant Pages

  • index already exists
    ... I'm not sure whether i'm running into a problem with hsqldb or more simply my understanding of SQL indexes is to pot. ... The DIVES table also has a column called Location_ID, so I know at which location the Dives was at. ...
    (comp.lang.java.databases)
  • Underwater Cameras
    ... friends that do alot of diving and are interested in photographing their ... dives. ... Prev by Date: ...
    (rec.photo.technique.nature)
  • Re: IPAQ Dive planning software
    ... FWIW I have used Nigel's prog for plenty of dives. ... kit. ... 'nuff said! ... Prev by Date: ...
    (uk.rec.scuba)
  • Tahiti
    ... Why is diving in the French Polynesuan islands so exspensive? ... Prev by Date: ...
    (rec.scuba.locations)
  • Re: Cozumel Anchor Ahoy
    ... > Cruise ships are always bad news. ... They might make good wreck dives... ... Prev by Date: ...
    (rec.scuba)