On 6/11/07, Fred Cox <[EMAIL PROTECTED]> wrote: > insert() - Invalid default timestamp: '(now() + '21 > days'::interval)' at > /usr/local/lib/perl5/site_perl/5.8.8/Rose/DB/Object.pm > line 1106 > > The column definition looks like this: > tsexpire | timestamp without time zone | not > null default (now() + '21 days'::interval) > > Should I expect valid default values to work? Or is > there a way I can get RDBO to allow Postgresql to come > up with the default value?
RDBO's trying to parse that as a date because it doesn't recognize it as something it should pass through unchanged. I'll think about how I can get it to recognize that, but in the meantime you can simply omit a default from your RDBO column definition, but keep the default in the database. After insert, the correct value should be present in the database, but you will have to load() your object to see the value on the perl side. -John ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
