After reading the mailing list, I still can't get the answer to this:
ERROR: copy: line 1, Bad timestamp external representation '28/04/2002
18:15:37.00 SGT'
lost synchronization with server, resetting connection
I'm using pg_dump from 7.1 to 7.2. When in postgresql, I run "select
current_timestamp;" and it came out:
timestamptz
--------------------------------
27/11/2002 21:40:46.602827 SGT
(1 row)
This is due to running "export PGDATESTYLE='european,sql' before postmaster.
So, I guess SGT is being recognised. However, when I changed the SGT to +08
in the dumped file, it works.
Can anyone help me?
