Additional: My notes say that it succeeded on ~/quicklisp/dists/quicklisp/software/postmodern-20110619-git and failed on ~/quicklisp/dists/quicklisp/software/postmodern-20110829-git .
-Luke On Fri, Feb 10, 2012 at 2:36 PM, Lucas Hope <lucas.r.h...@gmail.com> wrote: > Hi there, > > The following code sample used to work on postmodern-20110219-git (using > quicklisp from that period). However it now breaks. I can no longer insert > integers as dates or timestamps into tables. Updates don't work either, but > the example below uses insert: > > (ql:quickload "postmodern") ;; quicklisp version released yesterday > - postmodern-20111203-git > > (pomo:connect-toplevel "date_test" "snip" "snip" "localhost") > > (gethash "integer_datetimes" (pomo::connection-parameters pomo:*database*)) > => "on" > => T > > (pomo:execute "create table date ( value date );") > > (pomo:execute "insert into date ( value ) values ( $1 )" "2010-01-01") > > (setf date (pomo:query "select * from date limit 1" :single)) > => 3471292800 > > (ignore-errors (pomo:execute "insert into date ( value ) values ( $1 )" > date)) > => NIL > => #<CL-POSTGRES-ERROR:INVALID-DATETIME-FORMAT {1004A00391}> > > (pomo:execute "create table timestamp ( value timestamp );") > > (pomo:execute "insert into timestamp ( value ) values ( $1 )" "2010-01-01") > 1 > 1 > > (setf timestamp (pomo:query "select * from timestamp limit 1" :single)) > => 3471292800 > > (ignore-errors (pomo:execute "insert into timestamp ( value ) values ( $1 > )" timestamp)) > => NIL > => #<CL-POSTGRES-ERROR:INVALID-DATETIME-FORMAT {100403F391}> > > > -- > --------------------------------------------------- > Dr Lucas Hope - lucas.r.hope@skype > Machine Learning and Software Engineering Consultant > Melbourne, Australia > -- --------------------------------------------------- Dr Lucas Hope - lucas.r.hope@skype Machine Learning and Software Engineering Consultant Melbourne, Australia
_______________________________________________ postmodern-devel mailing list postmodern-devel@common-lisp.net http://lists.common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel