Hi there,<div><br></div><div>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&#39;t work either, but the example below uses insert:</div>
<div><br></div><div><div>(ql:quickload &quot;postmodern&quot;) ;; quicklisp version released yesterday - postmodern-20111203-git</div><div><br></div><div>(pomo:connect-toplevel &quot;date_test&quot; &quot;snip&quot; &quot;snip&quot; &quot;localhost&quot;)</div>
<div><br></div><div>(gethash &quot;integer_datetimes&quot; (pomo::connection-parameters pomo:*database*))</div><div>=&gt; &quot;on&quot;</div><div>=&gt; T</div><div><br></div><div>(pomo:execute &quot;create table date ( value date );&quot;)</div>
<div><br></div><div>(pomo:execute &quot;insert into date ( value ) values ( $1 )&quot; &quot;2010-01-01&quot;)</div><div><br></div><div>(setf date (pomo:query &quot;select * from date limit 1&quot; :single))</div><div>=&gt; 3471292800</div>
<div><br></div><div>(ignore-errors (pomo:execute &quot;insert into date ( value ) values ( $1 )&quot; date))</div><div>=&gt; NIL</div><div>=&gt; #&lt;CL-POSTGRES-ERROR:INVALID-DATETIME-FORMAT {1004A00391}&gt;</div><div><br>
</div><div>(pomo:execute &quot;create table timestamp ( value timestamp );&quot;)</div><div><br></div><div>(pomo:execute &quot;insert into timestamp ( value ) values ( $1 )&quot; &quot;2010-01-01&quot;)</div><div>1</div><div>
1</div><div><br></div><div>(setf timestamp (pomo:query &quot;select * from timestamp limit 1&quot; :single))</div><div>=&gt; 3471292800</div><div><br></div><div>(ignore-errors (pomo:execute &quot;insert into timestamp ( value ) values ( $1 )&quot; timestamp))</div>
<div>=&gt; NIL</div><div>=&gt; #&lt;CL-POSTGRES-ERROR:INVALID-DATETIME-FORMAT {100403F391}&gt;</div><div><br></div><div><br></div>-- <br>---------------------------------------------------<br>Dr Lucas Hope - lucas.r.hope@skype<br>
Machine Learning and Software Engineering Consultant<br>Melbourne, Australia<br>
</div>