Обсуждение: pg_get_indexdef (PostgreSQL 7.2 Snapshot)

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 (dpage@postgresql.org)
pgAdmin Project Leader
http://pgadmin.postgresql.org/

Dave Page <dpage@vale-housing.co.uk> writes:
> [ pg_get_indexdef doesn't report the predicate for a partial index ]

Hmm, looks like an oversight.  I agree it should do that.
Thanks for the report!

            regards, tom lane