Hi, I've been playing with a 7.2 snapshot downloaded from a mirror on 24 Sept. During the addition of support in pgAdmin II for constraint clauses in index definitions, I've found that for an index created with:
CREATE UNIQUE INDEX "constraint_index" ON "test" USING btree ("data") WHERE id < 12345 pg_get_indexdef(oid) returns: CREATE UNIQUE INDEX constraint_index ON test USING btree (data text_ops); (and yes I am passing the correct oid!). Please CC me any replies as I'm not on this list... Regards, Dave. -- Dave Page ([EMAIL PROTECTED]) pgAdmin Project Leader http://pgadmin.postgresql.org/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])