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])