| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Euler Taveira de Oliveira <euler(at)timbira(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Day and month name localization uses wrong |
| Date: | 2006-11-25 16:49:32 |
| Message-ID: | 20061125164932.GA7261@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian wrote:
>
> I now remember a new problem with this feature, irregardless of whether
> we use 'lc_messages' or 'lc_time'.
>
> The problem is having a function's output affected by a GUC variable.
> If you create an expression index using the function, and later query
> the index with a different GUC value, or you do inserts with different
> GUC values, the index will not work.
>
> I know we have had this problem in the past, but I can't remember if or
> how we addressed it.
Mark the function as volatile, which precludes from using it in a
functional index?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-11-25 17:33:48 | Re: Day and month name localization uses wrong |
| Previous Message | Bruce Momjian | 2006-11-25 16:27:45 | Re: Day and month name localization uses wrong |