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

[Chuck H. <ch...@gl...>]

On Jul 19, 2010, at 11:17 AM, Anjo Krank wrote:

> Changing a prototype is a very, very bad idea.

That depends on why you are changing it.  If it was just created incorrectly (and I _have_ seen this in Wonder), then fixing it is the Right Thing (tm) IMO.  Of course, the fix needs to not break for everyone else using it.  It totally depends on _what_ is wrong.

Chuck



> How was the table created?
> 
> Cheers, Anjo
> 
> 
> 
> Am 19.07.2010 um 16:48 schrieb Chuck Hill:
> 
>> On Jul 18, 2010, at 1:43 PM, Mark Wardle wrote:
>>> 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?
>> 
>> 
>> I am not using this combination, but fixing the prototype in Wonder would seem to be the correct answer.
>> 
>> Chuck
>> 
>> -- 
>> Chuck Hill             Senior Consultant / VP Development
>> 
>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.    
>> http://www.global-village.net/products/practical_webobjects
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> ------------------------------------------------------------------------------
>> This SF.net email is sponsored by Sprint
>> What will you do first with EVO, the first 4G phone?
>> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first_______________________________________________
>> Wonder-disc mailing list
>> Won...@li...
>> https://lists.sourceforge.net/lists/listinfo/wonder-disc
> 

-- 
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.    
http://www.global-village.net/products/practical_webobjects