{"action":"created","issue":{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/23","labels_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/23/labels{/name}","comments_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/23/comments","events_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/23/events","html_url":"https://github.com/ondras/wwwsqldesigner/issues/23","id":67084340,"number":23,"title":"Postgresql: serial/bigserial data types must be converted to integer/bigint in foreign keys","user":{"login":"ondras","id":192172,"avatar_url":"https://avatars.githubusercontent.com/u/192172?v=3","gravatar_id":"","url":"https://api.github.com/users/ondras","html_url":"https://github.com/ondras","followers_url":"https://api.github.com/users/ondras/followers","following_url":"https://api.github.com/users/ondras/following{/other_user}","gists_url":"https://api.github.com/users/ondras/gists{/gist_id}","starred_url":"https://api.github.com/users/ondras/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ondras/subscriptions","organizations_url":"https://api.github.com/users/ondras/orgs","repos_url":"https://api.github.com/users/ondras/repos","events_url":"https://api.github.com/users/ondras/events{/privacy}","received_events_url":"https://api.github.com/users/ondras/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/labels/imported","name":"imported","color":"FFFFFF"},{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/labels/Priority-Medium","name":"Priority-Medium","color":"FFFFFF"},{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/labels/Type-Other","name":"Type-Other","color":"FFFFFF"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-04-08T09:05:13Z","updated_at":"2015-04-08T09:05:25Z","closed_at":null,"body":"_From [i...@amarosia.com](https://code.google.com/u/115984126334797849605/) on April 23, 2009 04:25:12_\n\nWhat steps will reproduce the problem? 1. 'create foreign key' from a primary key of data type 'serial' 2. 3. What is the expected output? What do you see instead? the resultant foreign key is of data type serial. Should be 'integer' if\r\nreference column is 'serial' or 'bigint' if reference column is 'bigserial'. What version of the product are you using? On what operating system? 2.3.2 ubuntu 8.10 Please provide any additional information below. This is a Postgresql related issue. Serial/bigserial are pseudo-types\n\n_Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=16_"},"comment":{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/comments/90854693","html_url":"https://github.com/ondras/wwwsqldesigner/issues/23#issuecomment-90854693","issue_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/23","id":90854693,"user":{"login":"ondras","id":192172,"avatar_url":"https://avatars.githubusercontent.com/u/192172?v=3","gravatar_id":"","url":"https://api.github.com/users/ondras","html_url":"https://github.com/ondras","followers_url":"https://api.github.com/users/ondras/followers","following_url":"https://api.github.com/users/ondras/following{/other_user}","gists_url":"https://api.github.com/users/ondras/gists{/gist_id}","starred_url":"https://api.github.com/users/ondras/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ondras/subscriptions","organizations_url":"https://api.github.com/users/ondras/orgs","repos_url":"https://api.github.com/users/ondras/repos","events_url":"https://api.github.com/users/ondras/events{/privacy}","received_events_url":"https://api.github.com/users/ondras/received_events","type":"User","site_admin":false},"created_at":"2015-04-08T09:05:25Z","updated_at":"2015-04-08T09:05:25Z","body":"_From [ondrej.zara](https://code.google.com/u/ondrej.zara/) on April 23, 2009 04:27:40_\n\nIt is architecturally incorrect to make such database-specific adjustments in a code\r\nwhich is apriori DB agnostic.\r\n\r\nOn the other hand, I see that this could not be solved by means of modifications of\r\nPostgresql datatypes definition. I will try to make up some solution here."}}