[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