Bill wrote:
I've been getting the following error when i try to add a user toI use PostgreSQL 7.2 and 7.3β with TDK 2.1. Your problem doesn't ring any particular bells, but I've had trouble in the past with the type mappings that Torque uses to generate tables and classes. These mappings are stored in WEB-INF/build/bin/torque/templates/sql/base/postgresql/db.props. Specifically:
Turbine:
Six months ago, I switched from text to bytea for the VARBINARY type. This just might be your problem, since this is the type of the objectdata column in the TURBINE_USER table into which you are trying to insert. Search the mailing list archives for bytea to get the full story on the change.
Just the other day, I rebuilt my database under PostgreSQL 7.3β and found that TIMESTAMP columns had changed from using time zones to ignoring time zones. I had to manually specify I wanted timestamp(6) with time zone to get my application working again.
Hope this helps. I like PostgreSQL a lot and find it works great with Turbine.
--
Edwin Gustafson
Cayman Chemical Company
--
734 971 3586 x 221
http://www.caymanchem.com/promo/ewg
42*13'44" N 83*43'25" W
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
