| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Ken Williams <ken(at)mathforum(dot)org> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: automatic time zone conversion |
| Date: | 2002-06-12 14:31:34 |
| Message-ID: | 3D075B46.3EB294F4@fourpalms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
...
> I don't seem to be able to get rid of the time zone any of the
> ways I've tried.
I'm pretty sure that you are running a pre-7.2 database. Upgrade to get
the proper "without time zone" behavior; before 7.2 there was no
"without time zone" type, and the parser folded everything into the one
type that was available.
But you really want time zones from what you have said. You just want
them to behave properly. So make sure that your system is running with
the correct time zone, and make sure that you have specified the GUC
option to use Australian time zones (read the docs to get my rant about
Australia having fully one quarter of the time zones in PostgreSQL ;)
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-12 14:41:13 | Re: dynamic querys |
| Previous Message | Håkon Clausen | 2002-06-12 14:27:54 | how to get current database name in plpgsql function |