| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)au> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Question about 'copy' and datetime |
| Date: | 2001-01-22 05:34:37 |
| Message-ID: | 17361.980141677@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)au> writes:
> I find that when I try to restore a backup database (done by pg_dump),
> the datetime value seem inconsistent. I've checked the dumped file,
> the data seems alright. However, the imported date is +16hr of the
> date in the data file.
> The system uses EST. The data dumped also has EST postfix. Is this a
> bug or there are other options I need to set?
Given your return address, I'm betting this is a conflict between USA
and Aussie interpretations of "EST". You probably need to recompile
with USE_AUSTRALIAN_RULES #defined. See
http://www.postgresql.org/users-lounge/docs/7.0/postgres/datetime-appendix.htm
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Richter | 2001-01-22 06:20:14 | Joining several tables |
| Previous Message | Carolyn Lu Wong | 2001-01-22 04:08:30 | Question about 'copy' and datetime |