pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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