Re: pg_index question

Thanks Tom.

One never knows until he asks...

On Friday 25 March 2005 06:36 pm, Tom Lane saith:
> Scott Marlowe <smarlowe(at)g2switchworks(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Quote: 42
"In selecting men for office, let principle be your guide. Regard not
the particular sect or denomination of the candidate -- look to his
character...."

--Noah Webster

Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry(at)esc1(dot)com