| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Jorge Campins <jrcampins(at)cantv(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #3948: date/time functions returning wrong value |
| Date: | 2008-02-10 09:39:22 |
| Message-ID: | 47AEC64A.8060808@hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Jorge Campins wrote:
> How can I find which version I'm using? All I could see in pgAdmin is 8.1.
SELECT version();
> Which value should I use for timezone in postgresql.conf? I tried select
> * from pg_timezone_names to get a list of valid time zone names but it
> failed with "relation pg_timezone_names does not exist."
pg_timezone_names was added in 8.2. (which you really should upgrade to
anyway, since 8.1 isn't supported on Windows anymore)
To find it in 8.1, check the files in share/timezone in your PostgreSQL
installation.
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Szepe | 2008-02-10 09:53:17 | Re: 8.3.0: vacuum full analyze: "invalid memory alloc request size" |
| Previous Message | Magnus Hagander | 2008-02-10 09:37:48 | Re: BUG #3948: date/time functions returning wrong value |