{"action":"created","issue":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/139","repository_url":"https://api.github.com/repos/laurenz/oracle_fdw","labels_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/139/labels{/name}","comments_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/139/comments","events_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/139/events","html_url":"https://github.com/laurenz/oracle_fdw/issues/139","id":191995692,"number":139,"title":"PGAdmin hangs on selecting data from foreign table","user":{"login":"mbwiese","id":805117,"avatar_url":"https://avatars.githubusercontent.com/u/805117?v=3","gravatar_id":"","url":"https://api.github.com/users/mbwiese","html_url":"https://github.com/mbwiese","followers_url":"https://api.github.com/users/mbwiese/followers","following_url":"https://api.github.com/users/mbwiese/following{/other_user}","gists_url":"https://api.github.com/users/mbwiese/gists{/gist_id}","starred_url":"https://api.github.com/users/mbwiese/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbwiese/subscriptions","organizations_url":"https://api.github.com/users/mbwiese/orgs","repos_url":"https://api.github.com/users/mbwiese/repos","events_url":"https://api.github.com/users/mbwiese/events{/privacy}","received_events_url":"https://api.github.com/users/mbwiese/received_events","type":"User","site_admin":false},"labels":[{"id":189750464,"url":"https://api.github.com/repos/laurenz/oracle_fdw/labels/problem","name":"problem","color":"fbca04","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":11,"created_at":"2016-11-28T12:37:34Z","updated_at":"2016-12-05T13:18:18Z","closed_at":"2016-11-29T13:31:20Z","body":"I have defined a foreign table in PostGreSQL, refering to an oracle table at another server.\r\nPGAdmin stops responding whenever I try to view the data, and I have to kill PostgreSQL.exe manually (after 10 at least minutes)\r\nI have this problem both in PGAdmin III version 1.22.0 and in PGAdmin 4 version 1.11, therefore I think problem is not in PGAdmin.\r\nThis is the only foreign table I have defined at the moment.  It worked a couple of months ago.\r\n\r\nSELECT oracle_diag('servername') never returns.\r\nSELECT oracle_fdw oracle_diag() gives:\r\n**oracle_fdw 1.5.0, PostgreSQL 9.5.0, Oracle client 11.2.0.2.0, TNS_ADMIN=\\\\path\\to\\tnsnames.ora**\r\n\r\nI can see table data via SQLPlus from the server where PostGreSQL is installed.\r\n\r\n/Marianne"},"comment":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/comments/264851587","html_url":"https://github.com/laurenz/oracle_fdw/issues/139#issuecomment-264851587","issue_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/139","id":264851587,"user":{"login":"mbwiese","id":805117,"avatar_url":"https://avatars.githubusercontent.com/u/805117?v=3","gravatar_id":"","url":"https://api.github.com/users/mbwiese","html_url":"https://github.com/mbwiese","followers_url":"https://api.github.com/users/mbwiese/followers","following_url":"https://api.github.com/users/mbwiese/following{/other_user}","gists_url":"https://api.github.com/users/mbwiese/gists{/gist_id}","starred_url":"https://api.github.com/users/mbwiese/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbwiese/subscriptions","organizations_url":"https://api.github.com/users/mbwiese/orgs","repos_url":"https://api.github.com/users/mbwiese/repos","events_url":"https://api.github.com/users/mbwiese/events{/privacy}","received_events_url":"https://api.github.com/users/mbwiese/received_events","type":"User","site_admin":false},"created_at":"2016-12-05T13:18:18Z","updated_at":"2016-12-05T13:18:18Z","body":"How could I check that ? PostGreSQL login role 'postgres' is not a WIndows user. "}}
{"actor":{"display_login":"mbwiese"}}