ITADN

Problem with execute and the SET command?

#58Closedhoclun-rigsep 创建于 2025-05-18
H
hoclun-rigsepcommented
```clojure (pg/execute pg "SET LOCAL audit.email = $1" {:params ["email@email.com"]}) ``` gets me the following error: ``` org.pg.error.PGErrorResponse: Server error response: {severity=ERROR, code=42601, file=scan.l, line=1244, function=scanner_yyerror, position=25, message=syntax error at or near "$1", verbosity=ERROR}, sql: SET LOCAL audit.email = $1 ``` `(pg/execute pg "SELECT $1" {:params ["asdf@dog.com"]})` works normally: `[{:?column? "asdf@dog.com"}]` and so does `(pg/execute pg "SET LOCAL audit.email = 'email@email.com'")`. Is this expected? What's the right way to work around? Thank you for `pg2`
关闭于 2025-06-06 5 条评论