Peter Geoghegan <pg@bowt.ie> writes:
> Anyway, it's very hard to see how that could be, since the error in
> question is thrown from within the planner.
Yeah, there really shouldn't be any data dependency there.
> I don't recall the exact
> details of how inference will do offhand, but I am suspicious of the
> cast that appears in the partial index predicate.
That's expected given that the column is declared varchar.
The whole thing is pretty strange. I could believe the test not
finding an index whose state is changing (ie, it's in process of
being built by CREATE INDEX CONCURRENTLY), but as long as the
pg_index entry is stable it seems like it should either work or not.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs