| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamp skew during 7.4 -> 8.2 upgrade |
| Date: | 2007-08-10 10:14:26 |
| Message-ID: | 20070810101426.GA4487@merkur.hilbert.loc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Aug 10, 2007 at 10:11:29AM +0200, Louis-David Mitterrand wrote:
> So if I understand correctly, a timestamp_tz is ...
... stored as UTC in the backend
... sent to clients shifted by whatever timezone was
requested by the client by one of several mechanisms:
- "set timezone to ..." used by the client
- "select ... at time zone ..." used by the client
- the server timezone if neither of the above is used
> according to the host's timezone configuration? For example if I
> travel with my server and cross several timezones, my timestamp_tz's
> will display a different time (provided I run the tzselect utility in
> Linux) ?
Yes, unless the client tells the server to send them shifted
to a different timezone (see above).
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2007-08-10 10:35:51 | Re: Dell Hardware Recommendations |
| Previous Message | carter ck | 2007-08-10 09:46:11 | Database Select Slow |