Postgres Pro
Downloads
Home   >   mailing lists

Re: unaccent module - two params function should be immutable - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: unaccent module - two params function should be immutable
Date
Msg-id 20130911001410.GK16378@momjian.us
Whole thread Raw
In response to unaccent module - two params function should be immutable  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: unaccent module - two params function should be immutable
List pgsql-hackers
Tree view 
On Tue, Feb 19, 2013 at 08:30:29AM +0100, Pavel Stehule wrote:
> Hello
>
> There was a proposal to change flag of function to immutable - should
> be used in indexes
>
> CREATE FUNCTION unaccent(regdictionary, text)
>         RETURNS text
>         AS 'MODULE_PATHNAME', 'unaccent_dict'
>         LANGUAGE C STABLE STRICT;
>
>
> is there any progress?

I have developed the attached patch based on your suggestion.  I did not
see anything in the code that would make it STABLE, except a lookup of a
dictionary library:

        dictOid = get_ts_dict_oid(stringToQualifiedNameList("unaccent"), false);

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +
Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: A question about the psql \copy command
Next
From: Jeff Janes
Date:
Subject: 9.4 HEAD: select() failed in postmaster