{"action":"created","issue":{"url":"https://api.github.com/repos/yesodweb/persistent/issues/391","labels_url":"https://api.github.com/repos/yesodweb/persistent/issues/391/labels{/name}","comments_url":"https://api.github.com/repos/yesodweb/persistent/issues/391/comments","events_url":"https://api.github.com/repos/yesodweb/persistent/issues/391/events","html_url":"https://github.com/yesodweb/persistent/issues/391","id":71814717,"number":391,"title":"Postgres column type timezone leads to internal server error","user":{"login":"SKoschnicke","id":105162,"avatar_url":"https://avatars.githubusercontent.com/u/105162?v=3","gravatar_id":"","url":"https://api.github.com/users/SKoschnicke","html_url":"https://github.com/SKoschnicke","followers_url":"https://api.github.com/users/SKoschnicke/followers","following_url":"https://api.github.com/users/SKoschnicke/following{/other_user}","gists_url":"https://api.github.com/users/SKoschnicke/gists{/gist_id}","starred_url":"https://api.github.com/users/SKoschnicke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SKoschnicke/subscriptions","organizations_url":"https://api.github.com/users/SKoschnicke/orgs","repos_url":"https://api.github.com/users/SKoschnicke/repos","events_url":"https://api.github.com/users/SKoschnicke/events{/privacy}","received_events_url":"https://api.github.com/users/SKoschnicke/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/yesodweb/persistent/labels/in%20progress","name":"in progress","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"snoyberg","id":49415,"avatar_url":"https://avatars.githubusercontent.com/u/49415?v=3","gravatar_id":"","url":"https://api.github.com/users/snoyberg","html_url":"https://github.com/snoyberg","followers_url":"https://api.github.com/users/snoyberg/followers","following_url":"https://api.github.com/users/snoyberg/following{/other_user}","gists_url":"https://api.github.com/users/snoyberg/gists{/gist_id}","starred_url":"https://api.github.com/users/snoyberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snoyberg/subscriptions","organizations_url":"https://api.github.com/users/snoyberg/orgs","repos_url":"https://api.github.com/users/snoyberg/repos","events_url":"https://api.github.com/users/snoyberg/events{/privacy}","received_events_url":"https://api.github.com/users/snoyberg/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-04-29T08:33:36Z","updated_at":"2015-04-29T09:50:12Z","closed_at":null,"body":"I know that persistent 2.0 moved to using `timestamptz` in postgres for `UTCTime` fields and I suspect that existing fields of type `timestamp` get converted by a migration when updating to persistent 2.0. But it seems that using fields of the type `timestamp` is not possible anymore in the current persistent version: When having fields of type `timestamp` in the database and deactivated migrations, accessing a table with a `timestamp` field leads to an internal server error:\r\n\r\n```\r\nIncompatible {errSQLType = \"timestamp\", errSQLTableOid = Just (Oid 2911655112), errSQLField = \"\\240\\197\\175\\SOH\", errHaskellType = \"UTCTime\", errMessage = \"\"}\r\n```\r\n\r\nThis is a special situation (not using migrations and needing `timestamp` fields) but isn't it possible to just support this field type like `timestamptz` is supported?\r\n\r\nI created an application to showcase the error: https://github.com/SKoschnicke/persistent-timezone-problem"},"comment":{"url":"https://api.github.com/repos/yesodweb/persistent/issues/comments/97374105","html_url":"https://github.com/yesodweb/persistent/issues/391#issuecomment-97374105","issue_url":"https://api.github.com/repos/yesodweb/persistent/issues/391","id":97374105,"user":{"login":"snoyberg","id":49415,"avatar_url":"https://avatars.githubusercontent.com/u/49415?v=3","gravatar_id":"","url":"https://api.github.com/users/snoyberg","html_url":"https://github.com/snoyberg","followers_url":"https://api.github.com/users/snoyberg/followers","following_url":"https://api.github.com/users/snoyberg/following{/other_user}","gists_url":"https://api.github.com/users/snoyberg/gists{/gist_id}","starred_url":"https://api.github.com/users/snoyberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snoyberg/subscriptions","organizations_url":"https://api.github.com/users/snoyberg/orgs","repos_url":"https://api.github.com/users/snoyberg/repos","events_url":"https://api.github.com/users/snoyberg/events{/privacy}","received_events_url":"https://api.github.com/users/snoyberg/received_events","type":"User","site_admin":false},"created_at":"2015-04-29T09:50:12Z","updated_at":"2015-04-29T09:50:12Z","body":"I don't see a problem with the behavior you're asking for, and in fact I thought that persistent-postgresql would have supported it. The error message you're displaying comes from postgresql-simple. I'm not certain why it's happening, but I have a theory. Can you try out the commit I just pushed to the 391-timestamp branch and see if it resolves the problem for you? If so, I'll merge to master and release."}}