| From: | "Magnus Hagander" <magnus(at)hagander(dot)net> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | "Bruce Momjian" <bruce(at)momjian(dot)us>, jks(at)selectacast(dot)net, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: daylight savings patches needed? |
| Date: | 2007-02-13 06:40:36 |
| Message-ID: | 20070213064144.7A6C5DCC50A@svr2.hagander.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> >> So what happens if you have an old os with a new postgresql install?
> >> Will CURRENT_TIMESTAMP always return the correct value even if the
> >> system 'date' command is showing the wrong time?
>
> > Yes.
>
> Unless the user changes the system's clock setting (ie, its notion of
> the current UTC time) so that what he sees from "date" looks right.
>
> Also, what about Windows? I'm not clear whether Windows tries to keep
> system time in UTC or not. Even if it does, it'd be vulnerable to the
> same pilot-error problem.
It does.
/Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dfx | 2007-02-13 07:05:41 | Keyword OWNED not recognized in pg v. 8.1 |
| Previous Message | Shoaib Mir | 2007-02-13 06:27:03 | Re: Dumb question - how to tell if autovacuum is doing its job in 8.2.x |