pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Question about 'copy' and datetime 2+ messages / 2 participants [nested] [flat]
* Question about 'copy' and datetime @ 2001-01-22 04:08 Carolyn Lu Wong <carolyn@greatpacific.com.au> 2001-01-22 05:34 ` Re: Question about 'copy' and datetime Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Carolyn Lu Wong @ 2001-01-22 04:08 UTC (permalink / raw) To: pgsql-sql I'm using V6.5. 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? fyi, the command used in the backup script pg_dump -c -u -f $BACKUP_FILE $DATABASE and the command used in the restore script psql -e -u -f $BACKUP_FILE $DATABASE ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Question about 'copy' and datetime 2001-01-22 04:08 Question about 'copy' and datetime Carolyn Lu Wong <carolyn@greatpacific.com.au> @ 2001-01-22 05:34 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2001-01-22 05:34 UTC (permalink / raw) To: Carolyn Lu Wong <carolyn@greatpacific.com.au>; +Cc: pgsql-sql Carolyn Lu Wong <carolyn@greatpacific.com.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-22 05:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-01-22 04:08 Question about 'copy' and datetime Carolyn Lu Wong <carolyn@greatpacific.com.au> 2001-01-22 05:34 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox