Hi,

Using the @Index annotation does not seem to have any effect, whereas all the other markup works flawlessly (@OneToMany, etc..)

For instance, on a @Entity class, I have :

@Index(name = "cityName")
private String name;

The name property gets created, but no index is created. I am using PosgreSQL v8.1

So, my question is.. Is the org.hibernate.annotations.Index @Annotation taken into consideration by Hibernate Entity manager ?
Is there a specific step to enable its use ?

Thanks a lot,
sami dalouche

Hibernate version:
Hibernate EM : 3.1beta7
Hibernate : 3.2.0cr1

Mapping documents:
Using Annotations. @Entity on the class, and @Index(name="cityName") on the property that I'd like indexed

Name and version of the database you are using:
PostgreSQL v8.1

The latest versions works fine

Well, I tried with the latest version :
Hibernate 3.2CR2
Hibernate annotations 3.2.0CR1
Hibernate EntityManager 3.2CR1

and the indexes still don't get created...

the following:

/**
* The (US english) City name
*/
@Index(name = "cityName")
private String name;

should do it, right ?

Thanks a lot,
Sami Dalouche

Basically, what happens is that :
- if there is a @Unique, then an index gets created
- but @Index alone doesn't have any effect.

(Using Hibernate and PostgreSQL).

Well, I have same environment and have no trouble creating index on particular column. Look carefully in PgAdmin under table object you have indexes specified apart from column specification. Or you can try with explicitly specifying columnName under @Index annotation.

Best regards..

Do you mean that you can create the indexes on postgreSQL and have them used in Hibernate, or that Hibernate Entity Manager creates them automatically ?

Because my problem is that Hibernate EM does not create them..

Well, not Entity Manager, I use org.hibernate.tool.hbm2ddl.SchemaExport for that purpose. But answer is that index is created by Hibernate, not me ;)

Best regards..