{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/521","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/521/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/521/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/521/events","html_url":"https://github.com/npgsql/npgsql/issues/521","id":60000554,"number":521,"title":"Make unit tests run on Redshift","user":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/npgsql/npgsql/labels/infrastructure","name":"infrastructure","color":"c7def8"},{"url":"https://api.github.com/repos/npgsql/npgsql/labels/redshift","name":"redshift","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-03-05T19:13:16Z","updated_at":"2015-03-05T19:51:36Z","closed_at":null,"body":"We've been having several issues with running Npgsql on Redshift. It would be great to be able to run our unit tests on Redshift, this is currently impossible because of some unsupported types etc."},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/77438165","html_url":"https://github.com/npgsql/npgsql/issues/521#issuecomment-77438165","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/521","id":77438165,"user":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"created_at":"2015-03-05T19:51:36Z","updated_at":"2015-03-05T19:51:36Z","body":"@Emill that's a good place to start.\r\n\r\nI guess I'll start by trying to make our test suite initialize on Redshift, and flagging tests which rely on newer PostgreSQL (we already have the [MinPgVersion] attribute).\r\n\r\nI wonder if at some point we'll run against an actual Redshift/PostgreSQL incompatibility (as opposed to problems because Redshift is based on PG 8.0). Hopefully not.\r\n\r\nOnce this work is done, there's also the option of configuring the build server to automatically run tests against the test instance you created, and \"rolling\" the instance every 2 months as the free trial ends :)"}}