Hi Nicolas,
Still no luck reproducing this. Does this simple query fail too?
(query "select '’'")
If not, you might want to double-check your database encodings.
Best,
Marijn
___
postmodern-devel mailing list
postmodern-devel@common-lisp.net
http://co
According to
http://www.postgresql.org/docs/current/static/arrays.html#ARRAYS-INPUT
arrays should look like '{ val1 delim val2 delim ... }', but cl-postgres
sends them as {val1 ...}, the attached patch corrects this.
--
With Best Regards, Stas.
___
po
Stas Boukarev writes:
> According to
> http://www.postgresql.org/docs/current/static/arrays.html#ARRAYS-INPUT
> arrays should look like '{ val1 delim val2 delim ... }', but cl-postgres
> sends them as {val1 ...}, the attached patch corrects this.
Well, that was too soon, I forgot to attach the p
Stas Boukarev writes:
> Stas Boukarev writes:
>
>> According to
>> http://www.postgresql.org/docs/current/static/arrays.html#ARRAYS-INPUT
>> arrays should look like '{ val1 delim val2 delim ... }', but cl-postgres
>> sends them as {val1 ...}, the attached patch corrects this.
Aw, now I hit C-x
Hi Stas,
What happens when, with your patch, you try to pass an array as a
query parameter? ($1, etc) I suspect the correct thing to do would be
to return T as a second value from to-sql-string (which indicates that
the string should be escaped when put into a query), rather than
putting quotes in
Hi,
When trying to reproduce my encoding bug, I found a problem when a field
is named "t".
CREATE TABLE test (t TEXT NOT NULL);
(postmodern:execute (:insert-into 'test :set 't "utf8 é"))
Database error 42601: syntax error at or near "true"
Query: INSERT INTO test (true) VALUES (E'utf8 é')
[
cl:t, cl:nil, and :null have a special meaning in s-sql. In this case,
you can work around it by using :t or '#:t instead of 't in your
query.
___
postmodern-devel mailing list
postmodern-devel@common-lisp.net
http://common-lisp.net/cgi-bin/mailman/listi
Marijn Haverbeke writes:
> Hi Nicolas,
>
> Still no luck reproducing this. Does this simple query fail too?
> (query "select '’'")
All right, I finally figured out the problem. The string came from a
file, which was loaded with:
(defun file-read (filename)
(with-open-file (stream filename)
