Re: indexes on functions and create or replace function - Mailing list pgsql-general

From Christophe
Subject Re: indexes on functions and create or replace function
Date
Msg-id 1B411859-3DD0-4C2B-A48D-070BE57FA346@thebuild.com
Whole thread Raw
In response to Re: indexes on functions and create or replace function  ("Matthew Dennis" <mdennis@merfer.net>)
List pgsql-general
On Aug 28, 2008, at 7:22 PM, Matthew Dennis wrote:
> Yes, but in the case of pluggable languages, you still load
> something that constitutes the "source".  In the case of PL/Java,
> the jar for example.

This would mean that, for example, if you changed any single function
(no matter how distant and irrelevant to the one used to create a
functional index), the jar would change, so we would have to
invalidate all functional indexes written using functions contained
in that jar. I'd certainly rebel at that: It would make deploying a
new version of the jar very expensive, and unavoidably so.

I'd have to say that the current situation falls into the category of
"slightly annoying," but it has the benefit that whether or not to
rebuild the index is left up to me.

pgsql-general by date:

Previous
From: "Matthew Dennis"
Date:
Subject: Re: indexes on functions and create or replace function
Next
From: "Matthew Dennis"
Date:
Subject: Re: indexes on functions and create or replace function