[Wonder-disc] ERCAuditTrail, intBoolean, PostgreSQL and incorrect type

[Mark W. <ma...@wa...>]

Hi all,

I thought I'd emailed about this before but can't see it in my archives.

Jul 18 21:39:47 RSNews[5555] ERROR com.eldrix.news.app.DirectAction  -
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: <com.webobjects.jdbcadaptor.PostgresqlExpression: "INSERT INTO
ERCAuditTrail(GID, id, IS_DELETED) VALUES (?::varchar(255), ?::int4,
?::bool)" withBindings: 1:_EOIntegralKeyGlobalID[User
(java.lang.Integer)2](gid), 2:1(id), 3:false(isDeleted)>:
    Next exception:SQL State:42804 -- error code: 0 -- msg: ERROR:
column "is_deleted" is of type integer but expression is of type
boolean
  Hint: You will need to rewrite or cast the expression.
  Position: 84

PostgreSQL has tightened up on casting - needs to be explicit rather
than implicit.

I would have thought that this would have been handled by the
appropriate prototype (intBoolean) but this isn't the case.

I'm going to see whether I can get postgresql to relax its rules for
this table but is there a better fix?

Thanks,

Mark

-- 
Dr. Mark Wardle
Specialist registrar, Neurology
Cardiff, UK