Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: unaccent module - two params function should be immutable
Date
Msg-id CA+TgmoasAyS3bQw4VHZ+H_dUHqbbN2NcvKdAKZTZFSmjGNTj3A@mail.gmail.com
Whole thread Raw
In response to Re: 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 Sat, Sep 14, 2013 at 9:42 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> 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);
>
> yes, it risk, but similar is with timezones, and other external data.

That's a catalog lookup - not a reliance on external data.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Re: Proposal/design feedback needed: WITHIN GROUP (sql standard ordered set aggregate functions)
Next
From: Robert Haas
Date:
Subject: Re: json docs fixup