{"action":"opened","issue":{"url":"https://api.github.com/repos/citusdata/citus/issues/958","repository_url":"https://api.github.com/repos/citusdata/citus","labels_url":"https://api.github.com/repos/citusdata/citus/issues/958/labels{/name}","comments_url":"https://api.github.com/repos/citusdata/citus/issues/958/comments","events_url":"https://api.github.com/repos/citusdata/citus/issues/958/events","html_url":"https://github.com/citusdata/citus/issues/958","id":187810921,"number":958,"title":"Distributed foreign table creation fails with confusing message when column types are different","user":{"login":"mtuncer","id":9413470,"avatar_url":"https://avatars.githubusercontent.com/u/9413470?v=3","gravatar_id":"","url":"https://api.github.com/users/mtuncer","html_url":"https://github.com/mtuncer","followers_url":"https://api.github.com/users/mtuncer/followers","following_url":"https://api.github.com/users/mtuncer/following{/other_user}","gists_url":"https://api.github.com/users/mtuncer/gists{/gist_id}","starred_url":"https://api.github.com/users/mtuncer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtuncer/subscriptions","organizations_url":"https://api.github.com/users/mtuncer/orgs","repos_url":"https://api.github.com/users/mtuncer/repos","events_url":"https://api.github.com/users/mtuncer/events{/privacy}","received_events_url":"https://api.github.com/users/mtuncer/received_events","type":"User","site_admin":false},"labels":[{"id":320055696,"url":"https://api.github.com/repos/citusdata/citus/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-07T19:55:20Z","updated_at":"2016-11-07T19:55:20Z","closed_at":null,"body":"```sql\r\ncreate table t1(a int unique, b int);\r\ncreate table t2(a bigint references t1(a), b int);\r\nselect create_distributed_table('t1', 'a');\r\nselect create_distributed_table('t2', 'a');\r\n```\r\n\r\nResult\r\n```\r\nERROR:  cannot create foreign key constraint\r\nDETAIL:  Foreign key constraint can only be created on co-located tables.\r\n```\r\nExpected:\r\nError message should direct user to use same types in referrring and referred columns.\r\n"}}
{"actor":{"display_login":"mtuncer"}}