{"action":"created","issue":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/74","repository_url":"https://api.github.com/repos/laurenz/oracle_fdw","labels_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/74/labels{/name}","comments_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/74/comments","events_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/74/events","html_url":"https://github.com/laurenz/oracle_fdw/issues/74","id":143460802,"number":74,"title":"How to used ROWID in oracle_fdw?","user":{"login":"sangli00","id":3765918,"avatar_url":"https://avatars.githubusercontent.com/u/3765918?v=3","gravatar_id":"","url":"https://api.github.com/users/sangli00","html_url":"https://github.com/sangli00","followers_url":"https://api.github.com/users/sangli00/followers","following_url":"https://api.github.com/users/sangli00/following{/other_user}","gists_url":"https://api.github.com/users/sangli00/gists{/gist_id}","starred_url":"https://api.github.com/users/sangli00/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sangli00/subscriptions","organizations_url":"https://api.github.com/users/sangli00/orgs","repos_url":"https://api.github.com/users/sangli00/repos","events_url":"https://api.github.com/users/sangli00/events{/privacy}","received_events_url":"https://api.github.com/users/sangli00/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/laurenz/oracle_fdw/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-03-25T09:07:16Z","updated_at":"2016-03-28T09:47:37Z","closed_at":null,"body":"hi @laurenz \r\nI create oracle_fdw table \r\n\r\ncreate foreign table test(\r\ncol1 text,\r\n...\r\nrowid text\r\n);\r\nwhy not used rowid? \r\n"},"comment":{"url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/comments/202323840","html_url":"https://github.com/laurenz/oracle_fdw/issues/74#issuecomment-202323840","issue_url":"https://api.github.com/repos/laurenz/oracle_fdw/issues/74","id":202323840,"user":{"login":"laurenz","id":220612,"avatar_url":"https://avatars.githubusercontent.com/u/220612?v=3","gravatar_id":"","url":"https://api.github.com/users/laurenz","html_url":"https://github.com/laurenz","followers_url":"https://api.github.com/users/laurenz/followers","following_url":"https://api.github.com/users/laurenz/following{/other_user}","gists_url":"https://api.github.com/users/laurenz/gists{/gist_id}","starred_url":"https://api.github.com/users/laurenz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laurenz/subscriptions","organizations_url":"https://api.github.com/users/laurenz/orgs","repos_url":"https://api.github.com/users/laurenz/repos","events_url":"https://api.github.com/users/laurenz/events{/privacy}","received_events_url":"https://api.github.com/users/laurenz/received_events","type":"User","site_admin":false},"created_at":"2016-03-28T09:47:37Z","updated_at":"2016-03-28T09:47:37Z","body":"You didn't tell me *how* you modified oracle_fdw &hellip;\r\n\r\noracle_fdw will never push down a predicate like <tt>ROWID &gt; '&hellip;'</tt> because it does not push down string comparisons except <tt>=</tt> and <tt>&lt;&gt;</tt> because of character collation problems.\r\nI recommend that you use the primary key instead."}}