Re: pg_index question - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_index question
Date
Msg-id 16306.1111793781@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_index question  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: pg_index question  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: help w/ a little naive brainstorming ...
Next
From: OpenMacNews
Date:
Subject: Re: help w/ a little naive brainstorming ...