{"action":"created","issue":{"url":"https://api.github.com/repos/tpolecat/doobie/issues/411","repository_url":"https://api.github.com/repos/tpolecat/doobie","labels_url":"https://api.github.com/repos/tpolecat/doobie/issues/411/labels{/name}","comments_url":"https://api.github.com/repos/tpolecat/doobie/issues/411/comments","events_url":"https://api.github.com/repos/tpolecat/doobie/issues/411/events","html_url":"https://github.com/tpolecat/doobie/issues/411","id":195320506,"number":411,"title":"How can I set postgres schema search path for a connection?","user":{"login":"Daenyth","id":14644,"avatar_url":"https://avatars.githubusercontent.com/u/14644?v=3","gravatar_id":"","url":"https://api.github.com/users/Daenyth","html_url":"https://github.com/Daenyth","followers_url":"https://api.github.com/users/Daenyth/followers","following_url":"https://api.github.com/users/Daenyth/following{/other_user}","gists_url":"https://api.github.com/users/Daenyth/gists{/gist_id}","starred_url":"https://api.github.com/users/Daenyth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Daenyth/subscriptions","organizations_url":"https://api.github.com/users/Daenyth/orgs","repos_url":"https://api.github.com/users/Daenyth/repos","events_url":"https://api.github.com/users/Daenyth/events{/privacy}","received_events_url":"https://api.github.com/users/Daenyth/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-13T17:42:56Z","updated_at":"2016-12-13T17:45:40Z","closed_at":null,"body":"I'm trying to run a postgres query with a modified search_path. I'd like it to be set once on my transactor and then apply to all queries in a connection. Barring that, if I can do something with minimal boilerplate like `sql\"\"\"foo\"\"\".query[A].withSchema(\"abc\")` that would be reasonable"},"comment":{"url":"https://api.github.com/repos/tpolecat/doobie/issues/comments/266809031","html_url":"https://github.com/tpolecat/doobie/issues/411#issuecomment-266809031","issue_url":"https://api.github.com/repos/tpolecat/doobie/issues/411","id":266809031,"user":{"login":"Daenyth","id":14644,"avatar_url":"https://avatars.githubusercontent.com/u/14644?v=3","gravatar_id":"","url":"https://api.github.com/users/Daenyth","html_url":"https://github.com/Daenyth","followers_url":"https://api.github.com/users/Daenyth/followers","following_url":"https://api.github.com/users/Daenyth/following{/other_user}","gists_url":"https://api.github.com/users/Daenyth/gists{/gist_id}","starred_url":"https://api.github.com/users/Daenyth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Daenyth/subscriptions","organizations_url":"https://api.github.com/users/Daenyth/orgs","repos_url":"https://api.github.com/users/Daenyth/repos","events_url":"https://api.github.com/users/Daenyth/events{/privacy}","received_events_url":"https://api.github.com/users/Daenyth/received_events","type":"User","site_admin":false},"created_at":"2016-12-13T17:45:40Z","updated_at":"2016-12-13T17:45:40Z","body":"> https://gitter.im/tpolecat/doobie?at=585033457a58ca605549fc85\r\n\r\n> @Daenyth you can probably set this as an option for your connect URL. If not you say `val setSchema = sql\"set SEARCH_PATH = myschema\".update.run` and then instead of `stuff.transact(xa)` you can say `(setSchema *> stuff).transact(xa)`. As a last resort you can implement a custom transactor that does this in the \"before\" step."}}
{"actor":{"display_login":"Daenyth"}}