It seems that instead of 4 bytes of precision, it thinks it's 4 characters:
get_objects() - KH::RDBO::Zip: Value for lat() is too long. Maximum length is 4 characters. Value is 7 characters: 37.3053 at /usr/local/lib/perl5/site_perl/5 .8.8/Rose/Object.pm line 25 at lib/KH/Loader.pm line 33 Here's a portion of the generated classes: use strict; use base qw(KH::RDBO::DB::Object::AutoBase1); __PACKAGE__->meta->setup( table => 'deals', columns => [ id => { type => 'bigserial', not_null => 1 }, [...] lat => { type => 'float', precision => 4 }, lon => { type => 'float', precision => 4 } [...] ); The code that generated that looks like this: package KH::RDB; use strict; # http://search.cpan.org/~jsiracusa/Rose-DB-0.732/lib/Rose/DB/Tutorial.pod use Rose::DB; use Rose::DB::Object::Loader; our @ISA = ( 'Rose::DB' ); our $dbh; # use if you need access to the underlying DBI handle BEGIN { die "Set env for DB_DB, DB_HOST, DB_USER,and DB_PWORD\n" unless exists $ENV{DB_DB} && exists $ENV{DB_HOST} && exists $ENV{DB_USER} && exists $ENV{DB_PWORD}; } # Use a private registry for this class __PACKAGE__->use_private_registry; # Register your lone data source using the default type and domain __PACKAGE__->register_db( driver => 'pg', database => $ENV{DB_DB}, host => $ENV{DB_HOST}, username => $ENV{DB_USER}, password => $ENV{DB_PWORD} ); $dbh = new KH::RDB(); our $loader = new Rose::DB::Object::Loader( 'db' => $dbh, 'class_prefix' => 'KH::RDBO' ); our @classes; #QQQQ This takes one second, so we're going to want to freeze this in the future @classes = $loader->make_classes; 1; Any pointers on where to properly set the precision for floats? Thanks, Fred __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object