{"action":"created","issue":{"url":"https://api.github.com/repos/yesodweb/persistent/issues/454","labels_url":"https://api.github.com/repos/yesodweb/persistent/issues/454/labels{/name}","comments_url":"https://api.github.com/repos/yesodweb/persistent/issues/454/comments","events_url":"https://api.github.com/repos/yesodweb/persistent/issues/454/events","html_url":"https://github.com/yesodweb/persistent/issues/454","id":101510505,"number":454,"title":"Postgres sqltype=varchar(n) causes remigration","user":{"login":"myShoggoth","id":17465,"avatar_url":"https://avatars.githubusercontent.com/u/17465?v=3","gravatar_id":"","url":"https://api.github.com/users/myShoggoth","html_url":"https://github.com/myShoggoth","followers_url":"https://api.github.com/users/myShoggoth/followers","following_url":"https://api.github.com/users/myShoggoth/following{/other_user}","gists_url":"https://api.github.com/users/myShoggoth/gists{/gist_id}","starred_url":"https://api.github.com/users/myShoggoth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/myShoggoth/subscriptions","organizations_url":"https://api.github.com/users/myShoggoth/orgs","repos_url":"https://api.github.com/users/myShoggoth/repos","events_url":"https://api.github.com/users/myShoggoth/events{/privacy}","received_events_url":"https://api.github.com/users/myShoggoth/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-17T21:10:47Z","updated_at":"2015-08-18T01:24:43Z","closed_at":null,"body":"If I have an existing database and put in the model:\r\n\r\n     column Text Maybe sqltype=varchar(31)\r\n\r\nit will cause Persistent to remigrate every run because it doesn't seem to recognize that it is the same as the existing type.  Fixing it with:\r\n\r\n    column Text Maybe maxlen=31\r\n\r\nis great and is the real fix, but it is very difficult to track this down and both should be the same thing and interchangeable.  This can cause a failed migration when the column is part of a View in the db, for instance, and so altering the column type causes an sql error."},"comment":{"url":"https://api.github.com/repos/yesodweb/persistent/issues/comments/132021035","html_url":"https://github.com/yesodweb/persistent/issues/454#issuecomment-132021035","issue_url":"https://api.github.com/repos/yesodweb/persistent/issues/454","id":132021035,"user":{"login":"gregwebs","id":1183,"avatar_url":"https://avatars.githubusercontent.com/u/1183?v=3","gravatar_id":"","url":"https://api.github.com/users/gregwebs","html_url":"https://github.com/gregwebs","followers_url":"https://api.github.com/users/gregwebs/followers","following_url":"https://api.github.com/users/gregwebs/following{/other_user}","gists_url":"https://api.github.com/users/gregwebs/gists{/gist_id}","starred_url":"https://api.github.com/users/gregwebs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gregwebs/subscriptions","organizations_url":"https://api.github.com/users/gregwebs/orgs","repos_url":"https://api.github.com/users/gregwebs/repos","events_url":"https://api.github.com/users/gregwebs/events{/privacy}","received_events_url":"https://api.github.com/users/gregwebs/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T01:24:43Z","updated_at":"2015-08-18T01:24:43Z","body":"What db?"}}