Hi Ted,

I've closed one like that already as it belongs on WOProject JIRA.  Don't be 
offended if I close 517 for the same reasons...

http://issues.objectstyle.org/jira/browse/WONDER-438

The problem appears to be in the migration generation template.  It should be 
filed on JIRA for WOLips instead.  I see

http://issues.objectstyle.org/jira/browse/WOL-1029

which looks related. Maybe vote on that?

Michael,

I was not aware that the double migration itself did not work for Postgresql.  
File a jira for that issue on Wonder and I will take a look once I figure out 
git (^_^)  I suspect all you need to do is add Type.FLOAT and Type.DOUBLE into 
that tremendous 'if' statement in PostgresqlSQLHelper.externalTypeForJDBCType().

Ramsey


On Mar 27, 2011, at 7:59 AM, Theodore Petrosky wrote:

> I opened a Jira in April 2010 on this issue (Jira #517). Maybe adding a vote 
> to it would help move it along.
> 
> Ted
> 
>> Date: Fri, 25 Mar 2011 14:50:54 -0700
>> From: Michael Gargano <[email protected]>
>> Subject: PostgreSQL float8
>> To: "[email protected]
>> List List"
>>     <[email protected]>
>> Message-ID: <[email protected]>
>> Content-Type: text/plain; charset=us-ascii
>> 
>> Hi all,
>> 
>>     I'm using an attribute in my model with
>> a prototype of doubleNumber, this is set to use a DB type of
>> float8.  When I generate the migration it uses
>> .newDoubleColumn with broken precision and scale numbers
>> (since the prototype doesn't have these fields). 
>> Trying to use newDoubleColumn or even newColumn with
>> Types.DOUBLE or Types.FLOAT does not seem to work.  A
>> column gets created, but when my update script runs and
>> tries to insert data into that table it complains about the
>> numerical values I'm trying to insert claiming the field
>> type is 'money'.  I saw an earlier e-mail to the list
>> about this, but no resolution, but someone must be using
>> doubles and postgres somewhere.
>> 
>> Thanks.
>> -Mike
>> 
> 
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/ramseygurley%40gmail.com
> 
> This email sent to [email protected]

Attachment: smime.p7s
Description: S/MIME cryptographic signature

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to