[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] Re: [mv] *** Interchange 4.6 & PgSQL Difficulties ***
On Sat, 2 Dec 2000, Mike Heins wrote:
> Quoting David Wilson (david@wwns.com):
> >
> > 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.
Jon
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
