Problem with execute and the SET command?
```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 条评论