[ic] Problem with Pgsql timestamp

Wu-Sun Cheng interchange-users@interchange.redhat.com
Wed May 15 14:44:01 2002


Hi, I am using Interchange 4.8.5 with pgsql 7.1 which comes with RedHat
7.2.

Followings are two error messages I got while running demo "foundation"
with pgsql

- - - [15/May/2002:13:44:32 -0400] - - table 'orderline' failed: orderline
import failed: ERROR:  Bad timestamp external representation ''

- - - [15/May/2002:08:32:53 -0400] - - table 'transactions' failed:
transactions import failed: ERROR:  Bad timestamp external representation
''

I didn't change any original input files and both (orderline.txt and
transactions.txt) looks OK with me. So why I got the errors?

I had used same .txt files with perl database (GDBM) and didn't have any
problems before.

Regards, Wu-Sun