somewhere.
Here are technical information :
- I've launched my base (7.1.3 with cygwin) while TZ=GMT-2.
- To dump I use : pg_dump.exe -c -F c -Z 9 myDB
- To restore I use : zcat file.gz | pg_restore -v -c -F c -d myDB
For both dump and restore TZ is GMT-2.
Thanks for your hints...
Emm
Well, I've just solved the problem : I don't use anymore the TZ variable.
And now there is no more problem.
Though, I had to modify my programs to force the Timezone at each request.
If you have another workaround, just tell...
Emmanuel Guyot
"Emmanuel Guyot" <[EMAIL P
ht and is interpreted as 9:26
with GMT TimeZone, One hour is then added to the date. Is this right ??
If it is, why, with SQL datestyle, is it a bad syntax ?
Emmanuel Guyot
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
I hardly believe that noone knows about this problem.
Emmanuel Guyot
"Emmanuel Guyot" <[EMAIL PROTECTED]> a écrit dans le message de news:
9r11np$mk9$[EMAIL PROTECTED]
> I have some columns with timestamp data type wich includes the time zone.
> I access these columns u
