[ic] Problem with Pgsql timestamp
Wu-Sun Cheng
interchange-users@interchange.redhat.com
Wed May 15 16:26:00 2002
Hi, looks like the problem is pgsql could not take a blank as timestamp.
So I change both orderline.pgsql and transactions.pgsql as following:
Original:
Database orderline COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database orderline COLUMN_DEF "update_date=timestamp"
Modification:
Database orderline COLUMN_DEF "order_date=timestamp NOT NULL"
Database orderline COLUMN_DEF "update_date=varchar(32)"
Now not only I got two tables created correctly also I have "foundation"
function properly. Before I could not submit an order because I kept
getting
a misleading error such as:
9.37.223.254 f7fgDc4D:9.37.223.254 - [15/May/2002:10:54:41 -0400]
foundation /cgi-bin/foundation/process.html Route log failed.
9.37.223.254 f7fgDc4D:9.37.223.254 - [15/May/2002:10:54:41 -0400]
foundation /cgi-bin/foundation/process.html ERRORS on ORDER TEST0005:
> Error during creation of order routing log:
Regards, Wu-Sun
eServer xSeries Performance, IBM
(919) 254-6278
wcheng@us.ibm.com
>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