> The index that is failing is CREATE INDEX i1 ON conceptproperty USING btree > (codingschemename, property, propertyvalue). > I don't think you could create indexes on text fields... there are other type of indexes for that... tsearch2 for example -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings