Default to current_date. Charley
Chris Travers wrote: > I will get this error fixed today. What is the desired behavior for a > missing date? Error? default to current_date? What do people think? > > On 3/27/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: >> Peter Houppermans wrote: >>> Hmm, >>>>> I am getting an error with recording a payment (1.2.0RC5, Postgres >>>>> 8.1.8): >>>>> >>>>> *DBD::Pg::st execute failed: ERROR: invalid input syntax for type >>>>> date: "" >>>>> *Error! >>>>> >>>> Well what it is telling you is, the date you supplied for the payment >>>> is missing :). I don't actully recall if we supply that date or it if >>>> is supposed to be user supplied. >>>> >>> Would be nice if it had a slightly more friendly user decodable error >>> message - this would scare office staff into calling helpdesks.. >> Sure :), we accept patches. >> >> But seriously, you are correct we need to be catching errors but we are >> currently focusing on a whole slough of other issues right now. >> >> Joshua D. Drake >> >> >> >>> /// P /// >>> >>> >>> ------------------------------------------------------------------------ >>> >>> ------------------------------------------------------------------------- >>> 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 >>> >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> Ledger-smb-users mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> >> -- >> >> === The PostgreSQL Company: Command Prompt, Inc. === >> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 >> Providing the most comprehensive PostgreSQL solutions since 1997 >> http://www.commandprompt.com/ >> >> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate >> PostgreSQL Replication: http://www.commandprompt.com/products/ >> >> >> ------------------------------------------------------------------------- >> 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 >> _______________________________________________ >> Ledger-smb-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------- 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 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
