[ic] Solution to: 4.8.5 hangs with timeout when placing an order (PgSQL)

[interchange-users@icdevgroup.org (marc.brevoort)]

Hello group, 

After an upgrade to 4.8.5, I found that interchange crashes when placing an 
order. In my case, I was using a PostgreSQL database. Interchange would start 
up with a bit of SQL showing the definition of the table 'transactions'.

The file transactions.pgsql contains the structure for the table 
'transactions' in interchange, which is the table that holds orders. 
After changing the data type for field 'update_date' from type 'timestamp' to 
data type 'varchar(32)', interchange no longer crashed on ordering a product.

Explanation:

Interchange seems to attempt to use as-generic-as-possible SQL; 
the data type name 'varchar' is one of the few that is consistent in name and 
meaning across most versions of SQL. Possibly this is why most fields 
(including fields such as 'quantity') are defined as text fields.

Hope this benefits someone.

grtz
MRJB