{"action":"created","issue":{"url":"https://api.github.com/repos/nim-lang/Nim/issues/3560","labels_url":"https://api.github.com/repos/nim-lang/Nim/issues/3560/labels{/name}","comments_url":"https://api.github.com/repos/nim-lang/Nim/issues/3560/comments","events_url":"https://api.github.com/repos/nim-lang/Nim/issues/3560/events","html_url":"https://github.com/nim-lang/Nim/issues/3560","id":117745396,"number":3560,"title":"db_postgres broken in v0.12.0?","user":{"login":"boydgreenfield","id":535969,"avatar_url":"https://avatars.githubusercontent.com/u/535969?v=3","gravatar_id":"","url":"https://api.github.com/users/boydgreenfield","html_url":"https://github.com/boydgreenfield","followers_url":"https://api.github.com/users/boydgreenfield/followers","following_url":"https://api.github.com/users/boydgreenfield/following{/other_user}","gists_url":"https://api.github.com/users/boydgreenfield/gists{/gist_id}","starred_url":"https://api.github.com/users/boydgreenfield/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boydgreenfield/subscriptions","organizations_url":"https://api.github.com/users/boydgreenfield/orgs","repos_url":"https://api.github.com/users/boydgreenfield/repos","events_url":"https://api.github.com/users/boydgreenfield/events{/privacy}","received_events_url":"https://api.github.com/users/boydgreenfield/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/nim-lang/Nim/labels/Showstopper","name":"Showstopper","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"dom96","id":246651,"avatar_url":"https://avatars.githubusercontent.com/u/246651?v=3","gravatar_id":"","url":"https://api.github.com/users/dom96","html_url":"https://github.com/dom96","followers_url":"https://api.github.com/users/dom96/followers","following_url":"https://api.github.com/users/dom96/following{/other_user}","gists_url":"https://api.github.com/users/dom96/gists{/gist_id}","starred_url":"https://api.github.com/users/dom96/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dom96/subscriptions","organizations_url":"https://api.github.com/users/dom96/orgs","repos_url":"https://api.github.com/users/dom96/repos","events_url":"https://api.github.com/users/dom96/events{/privacy}","received_events_url":"https://api.github.com/users/dom96/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-11-19T05:36:13Z","updated_at":"2015-11-19T22:24:38Z","closed_at":null,"body":"I'm getting a variety of odd errors with Nim v0.12.0 and the `db_postgres` module, which I suspect are related to this pull request (https://github.com/nim-lang/Nim/pull/3334) and this issue (https://github.com/nim-lang/Nim/issues/3430).\r\n\r\nFor example, the following insert `conn.insertId(sql(\"INSERT into files (id, name) VALUES (?, ?)\"), fileId, fileName)` fails as it's being treated like a prepared statement:\r\n\r\n```\r\nError: unhandled exception: ERROR:  prepared statement \"setupQuery_Query_INSERT into files (id, name) VALUES (?, ?) RETURNING id\" does not exist\r\n [EDb]\r\n```\r\n\r\nHere's a gist for reproducing the above error (note one needs to `psql -c 'create database test;'` for this to work: https://gist.github.com/boydgreenfield/5e139345dfd150618153\r\n\r\nNeedless to say, this is a big breaking regression if I've not done something really silly or missed a syntax change."},"comment":{"url":"https://api.github.com/repos/nim-lang/Nim/issues/comments/158219679","html_url":"https://github.com/nim-lang/Nim/issues/3560#issuecomment-158219679","issue_url":"https://api.github.com/repos/nim-lang/Nim/issues/3560","id":158219679,"user":{"login":"dom96","id":246651,"avatar_url":"https://avatars.githubusercontent.com/u/246651?v=3","gravatar_id":"","url":"https://api.github.com/users/dom96","html_url":"https://github.com/dom96","followers_url":"https://api.github.com/users/dom96/followers","following_url":"https://api.github.com/users/dom96/following{/other_user}","gists_url":"https://api.github.com/users/dom96/gists{/gist_id}","starred_url":"https://api.github.com/users/dom96/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dom96/subscriptions","organizations_url":"https://api.github.com/users/dom96/orgs","repos_url":"https://api.github.com/users/dom96/repos","events_url":"https://api.github.com/users/dom96/events{/privacy}","received_events_url":"https://api.github.com/users/dom96/received_events","type":"User","site_admin":false},"created_at":"2015-11-19T22:24:38Z","updated_at":"2015-11-19T22:24:38Z","body":"@boydgreenfield Just tested it, this seems incorrect https://gist.github.com/boydgreenfield/5e139345dfd150618153#file-new_test-nim-L5, change ``name`` to ``filename`` in the sql query."}}