| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Chris Hoover <revoohc(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: 8.2.4 Won't Build 8.1 Functional Indexes |
| Date: | 2007-06-07 01:52:37 |
| Message-ID: | 20070607015237.GA30257@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Tom Lane escribió:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > You can't do this because to_date and other functions are not immutable.
> > 8.2 seems to be more picky about this -- the date conversions of
> > timestamptz columns are dependent on the current timezone.
>
> The reason 8.2 is more picky is that the function is less immutable
> thanks to the addition of locale-dependent functionality:
> http://archives.postgresql.org/pgsql-committers/2006-11/msg00264.php
Ah. It was a good try in any case I think :-P The reason I confused the
issue is that I had been fiddling with date_trunc on a timestamptz
column and found that it didn't really work as I expected. (I can't
recall exactly ATM but I think it was 8.1 anyway).
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Hoover | 2007-06-07 02:16:35 | Re: 8.2.4 Won't Build 8.1 Functional Indexes |
| Previous Message | Peter Koczan | 2007-06-07 00:51:15 | Re: troubleshooting "idle in transaction" |