[ic] Re: [mv] *** Interchange 4.6 & PgSQL Difficulties ***

[David Wilson]

Great!

Thanks Mike.  I saw some of the earlier things on the mailing list about
it, but this makes it much clearer.

Dave

Mike Heins wrote...
> 
> Quoting David Wilson (david@wwns.com):
> > Hello fellows,
> > 
> > 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.
> 
> Just edit the files dbconf/pgsql/* and change all timestamp fields to
> varchar(32).
> 
> Alternatively, you can play around with MVC_SQLUDATE in the
> INTERCHANGE_ROOT/construct/config/additional_fields file and change
> its value for Postgres to fit 7.x, or you can edit the .txt files
> and do something, or.....
> 
> All of this is not impossible to figure out, just grep recursively for
> timestamp and take action.
> 
> -- 
> Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
> phone +1.513.523.7621 fax 7501 <heins@akopia.com>
> 
> Be patient. God isn't finished with me yet.  -- unknown
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
> 


-- 
David R. Wilson
World Wide Network Services
Nashville, Tennessee USA
david@wwns.com