operator family changes, sinval bug?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: operator family changes, sinval bug?
Date: 2015-06-26 00:32:04
Message-ID: CAMkU=1xx1_Rj24xjQcqHo-Gjk0rh_XaocWAW=br=My-Ac=3X-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

When I drop the optional triconsistent support function for a gin index
operator family, the system continues to use the function to support index
queries anyway, until I close the session and restart it, at which point it
reverts to using the binary consistent function.

Is this a bug in the cache invalidation mechanism? Or am I just expecting
too much of it?

On one occasion, I got a
ERROR: cache lookup failed for function 16442
when trying to do the query using the gin index, but usually it just
continues to work as expected even though it is invoking a function which
no longer exists.

I see the same behavior in both 9.4.4 and in HEAD.

Cheers,

Jeff

alter operator family gin_foobar_ops using gin drop function 6 (text,text);
drop function gin_foobar_triconsistent ( internal, smallint, text, integer,
internal, internal, internal) ;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-06-26 05:50:05 Re: Re: windows 8 RTM compatibility issue (could not reserve shared memory region for child)
Previous Message brsaweda 2015-06-25 19:24:03 BUG #13469: Systematic typo in dblink documentation