[postmodern-devel] table name problem
15 Feb
2011
15 Feb
'11
7:38 a.m.
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 é') [Condition of type CL-POSTGRES-ERROR:SYNTAX-ERROR-OR-ACCESS-VIOLATION] Regards, -- Nicolas Martyanoff http://codemore.org khaelin@gmail.com
15 Feb
15 Feb
7:44 a.m.
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.
5109
Age (days ago)
5109
Last active (days ago)
1 comments
2 participants
participants (2)
-
Marijn Haverbeke
-
Nicolas Martyanoff