[ic] Re: [mv] *** Interchange 4.6 & PgSQL Difficulties ***
Sun, 3 Dec 2000 02:18:04 -0600 (CST)
On Sat, 2 Dec 2000, Mike Heins wrote:
> Quoting David Wilson (firstname.lastname@example.org):
> > I installed the tar files for Postgres 7.0.3 IC 4.6.0 and have the same
> > problems with the construct demo. I am installing it on RH 6.2.
> > I have not found any documentation on the mailing lists for Interchange
> > or Postgres that seem to have a solution. Any good ideas? It seems that
> > when Interchange is started it makes it past initializing the table
> > orderline before it gives this error message and aborts initializing any
> > other tables.
> Aha. I think this is a PostgreSQL 7 issue. They changed their timestamp
> representation (do a Deja search and you will see other complaints/problems
> about it), and I have tested only on 6.5.x. Works fine on 6.5.x.
Actually, I think this may be due to PostgreSQL 7 not allowing empty
timestamp fields. A few of the rows recently added to the transactions and
orderline tables had empty timestamps, and filling them with a valid
timestamp fixed the problem. I've fixed our default data in CVS and 4.6.1.
Of course switching the column to a VARCHAR as Mike suggested would also
work and would be tolerant of such anomalous timestamps in the future.