Re: pg_index question

Scott Marlowe <smarlowe@g2switchworks.com> writes:
> Umm, I tried it and it worked.  Sure you got the right relid?

I think the relation cache will probably not notice a manual update on
pg_index.  So whether it "works" or not would depend on a lot of
extraneous factors like whether the relation cache entry was already
built for the target table and whether you did something else that would
force a cache rebuild.

In any case, the whole idea is so fraught with pitfalls that I couldn't
recommend it ...

            regards, tom lane