The following little fragment of sql does what I'd like it to do, inserts the current timestamp into the created_date column.
create table mooses ( id integer primary key autoincrement, name text, created_date datetime not null default current_timestamp ); insert into mooses(name) values ('B. Moose'); insert into mooses(name) values ('Big Tex'); select * from mooses; If I use Rose::DB::Object::Loader on the database created with the above, it complains with: insert() - Invalid default datetime: 'current_timestamp' at ... Object.pm If I change Rose::DB::SQLite::validate_datetime_keyword so that it'll accept 'current_timestamp' then the value gets inserted literally into the table. I'd like to be able to specify the default behaviour in the schema, it'll be more robust if/when it's used outside of rdbo. Is there a proper way to make this work? g. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object