{"action":"created","issue":{"url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/558","repository_url":"https://api.github.com/repos/pgjdbc/pgjdbc","labels_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/558/labels{/name}","comments_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/558/comments","events_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/558/events","html_url":"https://github.com/pgjdbc/pgjdbc/issues/558","id":154118688,"number":558,"title":"Replication protocol required support the simple query protocol for v3","user":{"login":"Gordiychuk","id":10699594,"avatar_url":"https://avatars.githubusercontent.com/u/10699594?v=3","gravatar_id":"","url":"https://api.github.com/users/Gordiychuk","html_url":"https://github.com/Gordiychuk","followers_url":"https://api.github.com/users/Gordiychuk/followers","following_url":"https://api.github.com/users/Gordiychuk/following{/other_user}","gists_url":"https://api.github.com/users/Gordiychuk/gists{/gist_id}","starred_url":"https://api.github.com/users/Gordiychuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gordiychuk/subscriptions","organizations_url":"https://api.github.com/users/Gordiychuk/orgs","repos_url":"https://api.github.com/users/Gordiychuk/repos","events_url":"https://api.github.com/users/Gordiychuk/events{/privacy}","received_events_url":"https://api.github.com/users/Gordiychuk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-10T22:11:53Z","updated_at":"2016-05-10T22:14:36Z","closed_at":null,"body":"I found few PR about support the simple query format for v3 protocol https://github.com/pgjdbc/pgjdbc/pull/365 and https://github.com/pgjdbc/pgjdbc/pull/450 . But all PR was close without merge. \r\n\r\nI add support replication protocol in PR https://github.com/pgjdbc/pgjdbc/pull/550 and found problem with current v3 protocol implementation - Absent ability execute statement as simple query(only extended query). But in walsender mode only the simple query protocol can be used, see [Streaming Replication Protocol](http://www.postgresql.org/docs/devel/static/protocol-replication.html). As result even org.postgresql.jdbc.PgConnection#isValid fail with exception that not allow use pooling for replication connections. \r\n\r\nWhat about execute all query without parameters and not prepared as simple query? Is it real or need add additional flag about ability use the simple query protocol if it available in specific case?\r\n\r\nI also think that will be good if backend will reply us after start package which query mode available for use: extended or simple."},"comment":{"url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/comments/218308078","html_url":"https://github.com/pgjdbc/pgjdbc/issues/558#issuecomment-218308078","issue_url":"https://api.github.com/repos/pgjdbc/pgjdbc/issues/558","id":218308078,"user":{"login":"Gordiychuk","id":10699594,"avatar_url":"https://avatars.githubusercontent.com/u/10699594?v=3","gravatar_id":"","url":"https://api.github.com/users/Gordiychuk","html_url":"https://github.com/Gordiychuk","followers_url":"https://api.github.com/users/Gordiychuk/followers","following_url":"https://api.github.com/users/Gordiychuk/following{/other_user}","gists_url":"https://api.github.com/users/Gordiychuk/gists{/gist_id}","starred_url":"https://api.github.com/users/Gordiychuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gordiychuk/subscriptions","organizations_url":"https://api.github.com/users/Gordiychuk/orgs","repos_url":"https://api.github.com/users/Gordiychuk/repos","events_url":"https://api.github.com/users/Gordiychuk/events{/privacy}","received_events_url":"https://api.github.com/users/Gordiychuk/received_events","type":"User","site_admin":false},"created_at":"2016-05-10T22:14:36Z","updated_at":"2016-05-10T22:14:36Z","body":"I want to know your opinions before implementing."}}