postmodern-devel

Download

postmodern-devel@common-lisp.net

November 2013

3 participants
2 discussions

Parsing for double precision not working yet
by Daniel Brunner 28 Nov '13

28 Nov '13

[NB: Marjin, I already posted this issue on Github] Hello! There is a problem with columns with double precision. Test case: --8<-- (pomo:query "create table ftest (value double precision)") (pomo:query "insert into ftest values ($1)" (coerce 100.10 'double-float)) --8<-- This fails with: --8<-- Database error 22P02: invalid input syntax for type double precision: "100.0999984741211D0" [Condition of type CL-POSTGRES-ERROR:DATA-EXCEPTION] --8<-- A short patch in cl-postgres/sql-string.lisp could solve that problem: --8<-- diff --git a/cl-postgres/sql-string.lisp b/cl-postgres/sql-string.lisp index 3157d30..4dff4be 100644 --- a/cl-postgres/sql-string.lisp +++ b/cl-postgres/sql-string.lisp @@ -84,6 +84,8 @@ whether the string should be escaped before being put into a query.") (princ-to-string arg)) (:method ((arg float)) (format nil "~f" arg)) + (:method ((arg double-float)) + (format nil "~,,,,,,'EE" arg)) (:method ((arg ratio)) ;; Possible optimization: we could probably build up the same binary structure postgres --8<-- Best wishes, Daniel

2 1

[postmodern-devel] A question about connection pooling, and the many ways to connect.
by Jim Barrows 12 Nov '13

12 Nov '13

I'm a java developer, and I think I'm expecting something to happen that's not. In Java I setup a pooled connection, and just use it. The connections pool themselves. I had thought that by doing: (setf *database* (connect "PomBanDone" "pombandone" "pombandone" "localhost" :pooled-p T))) that I would get connection pooling. However now that I'm getting a better understanding of Lisp and I think Postmodern, that connections aren't getting pooled. I think I have to use (with-connection (spec &body body) in order to make the connection pooling work. Is that the case? If not, why would I want to use with-connection? Thanks! -- James A Barrows

3 2