[jifty-devel] Database setup question

Alex Vandiver alexmv at bestpractical.com
Wed Apr 26 20:15:46 EDT 2006


On Fri, 2006-04-21 at 18:09 -0400, Bort, Paul wrote:
> The column contains a timestamp, and I'd like it to default to the time
> the record was inserted. This is no problem in PG: 
> [snip]
> Any ideas? Undocumented magic quote control? I'd rather not have to
> change the schema outside Jifty if possible.

Done, in r936 -- though it takes at least DBIx::DBSchema 0.29.  You can
now say:

column created_on =>
    label is 'Date this test was created',
    type is 'timestamp',
    default is literal 'now()';

I was considering the option of:
    default is 'now()', literally;

..but it seemed a bit *too* casual. ;>
 - Alex


More information about the jifty-devel mailing list