Re: [BUGS] pg_get_indexdef (PostgreSQL 7.2 Snapshot)

2001-10-01 Thread Tom Lane
Dave Page <[EMAIL PROTECTED]> 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 ---(end of broadcast)--

[BUGS] pg_get_indexdef (PostgreSQL 7.2 Snapshot)

2001-10-01 Thread Dave Page
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 < 123