On Aug 7, 2007 4:12 PM, George Hartzell <[EMAIL PROTECTED]> wrote:
> 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
This is fixed in SVN. Such columns will not get a default value of "now"
-John
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
