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

Reply via email to