Clodoaldo Neto wrote > How does the planner know that the function used in an index has changed? > If the function's body is changed keeping the argument and return types > the > planner will not use it anymore: Not a hacker but the function catalog entry is MVCC just like any other record and so even if you alter the function without changing the signature the system still knows that something has changed. Since the system cannot inspect the function change to know whether the original and new function provide the same output given the same input it can no longer trust the index. For me the "how" doesn't matter and it is working as expected. Do you have some larger intent than just understanding how that you have not made clear? David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Changing-the-function-used-in-an-index-tp5763581p5763582.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
