{"action":"created","issue":{"url":"https://api.github.com/repos/brianc/node-postgres/issues/812","labels_url":"https://api.github.com/repos/brianc/node-postgres/issues/812/labels{/name}","comments_url":"https://api.github.com/repos/brianc/node-postgres/issues/812/comments","events_url":"https://api.github.com/repos/brianc/node-postgres/issues/812/events","html_url":"https://github.com/brianc/node-postgres/issues/812","id":92745441,"number":812,"title":"Can't parameterize an anonymous block?","user":{"login":"NoMoreNicksLeft","id":202136,"avatar_url":"https://avatars.githubusercontent.com/u/202136?v=3","gravatar_id":"","url":"https://api.github.com/users/NoMoreNicksLeft","html_url":"https://github.com/NoMoreNicksLeft","followers_url":"https://api.github.com/users/NoMoreNicksLeft/followers","following_url":"https://api.github.com/users/NoMoreNicksLeft/following{/other_user}","gists_url":"https://api.github.com/users/NoMoreNicksLeft/gists{/gist_id}","starred_url":"https://api.github.com/users/NoMoreNicksLeft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NoMoreNicksLeft/subscriptions","organizations_url":"https://api.github.com/users/NoMoreNicksLeft/orgs","repos_url":"https://api.github.com/users/NoMoreNicksLeft/repos","events_url":"https://api.github.com/users/NoMoreNicksLeft/events{/privacy}","received_events_url":"https://api.github.com/users/NoMoreNicksLeft/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-07-02T22:05:13Z","updated_at":"2015-08-12T13:54:09Z","closed_at":"2015-08-12T13:54:09Z","body":"I have an anonymous block (Postgres' DO statement) which I supply a parameter to, but I receive this:\r\n\r\n    error: bind message supplies 1 parameters, but prepared statement \"\" requires 0\r\n\r\nI am unable to determine if this is a limitation of Postgres itself or node-postgres, the anonymous block itself can't have parameters, but if this is being chucked into an anonymous prepared statement... Can anyone shed some light on this?\r\n\r\nIf it is possible, support would be really useful. I have a situation where doing several inserts one at a time in node would cause issues, and being able to send them along as a single monolithic block simplifies things greatly."},"comment":{"url":"https://api.github.com/repos/brianc/node-postgres/issues/comments/130313721","html_url":"https://github.com/brianc/node-postgres/issues/812#issuecomment-130313721","issue_url":"https://api.github.com/repos/brianc/node-postgres/issues/812","id":130313721,"user":{"login":"brianc","id":50081,"avatar_url":"https://avatars.githubusercontent.com/u/50081?v=3","gravatar_id":"","url":"https://api.github.com/users/brianc","html_url":"https://github.com/brianc","followers_url":"https://api.github.com/users/brianc/followers","following_url":"https://api.github.com/users/brianc/following{/other_user}","gists_url":"https://api.github.com/users/brianc/gists{/gist_id}","starred_url":"https://api.github.com/users/brianc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brianc/subscriptions","organizations_url":"https://api.github.com/users/brianc/orgs","repos_url":"https://api.github.com/users/brianc/repos","events_url":"https://api.github.com/users/brianc/events{/privacy}","received_events_url":"https://api.github.com/users/brianc/received_events","type":"User","site_admin":false},"created_at":"2015-08-12T13:54:09Z","updated_at":"2015-08-12T13:54:09Z","body":"Closing this - more of a postgres question than node-postgres me thinks & @sehrope did a bang up job on the answer! :clap: "}}