On Sat, 5 Apr 2008, Alex Povolotsky wrote:
Jess Robinson wrote:On Thu, 3 Apr 2008, Alex Povolotsky wrote:Hello!Attempt to insert into postgres table with undef's for columns with default values yields an error. It is especially bad with find_or_create sub.Are those columns also nullable, or not? If they're not, inserting null/undef doesn't make sense.. In DBIx::Class or plain SQL. the solution is generally to insert \'DEFAULT' ..Well, how do you pass DEFAULT (not 'DEFAULT' string, but DEFAULT SQL keyword) to DBI?
Using a literal string like that:
{ mycol => \'DEFAULT' }
Jess
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
