[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] Re: [mv] *** Interchange 4.6 & PgSQL Difficulties ***
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
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
