{"action":"created","issue":{"url":"https://api.github.com/repos/brianc/node-postgres/issues/1166","repository_url":"https://api.github.com/repos/brianc/node-postgres","labels_url":"https://api.github.com/repos/brianc/node-postgres/issues/1166/labels{/name}","comments_url":"https://api.github.com/repos/brianc/node-postgres/issues/1166/comments","events_url":"https://api.github.com/repos/brianc/node-postgres/issues/1166/events","html_url":"https://github.com/brianc/node-postgres/issues/1166","id":188625901,"number":1166,"title":"Writing 80K bytea columns","user":{"login":"jdabbs003","id":13259829,"avatar_url":"https://avatars.githubusercontent.com/u/13259829?v=3","gravatar_id":"","url":"https://api.github.com/users/jdabbs003","html_url":"https://github.com/jdabbs003","followers_url":"https://api.github.com/users/jdabbs003/followers","following_url":"https://api.github.com/users/jdabbs003/following{/other_user}","gists_url":"https://api.github.com/users/jdabbs003/gists{/gist_id}","starred_url":"https://api.github.com/users/jdabbs003/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdabbs003/subscriptions","organizations_url":"https://api.github.com/users/jdabbs003/orgs","repos_url":"https://api.github.com/users/jdabbs003/repos","events_url":"https://api.github.com/users/jdabbs003/events{/privacy}","received_events_url":"https://api.github.com/users/jdabbs003/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-11-10T21:41:26Z","updated_at":"2016-11-14T18:45:13Z","closed_at":null,"body":"I'm trying to insert a row with a bytea column, using a Uint8Array variable.\r\n\r\n`pool.queryPool\r\n(\r\n\"INSERT INTO DeviceOS (elf_file) VALUES($1::bytea)\",\r\n[elf_file],\r\nfunction(err, result) {...});`\r\n\r\n`elf_file` is a `Uint8Array`\r\n\r\nThe operation fails.  In the callback:\r\n`err.code` ends up being `'22001'`\r\n`err.message` ends up being `'value too long for type character varying(1024)'`\r\n\r\nIs this a bug or operator error?  Is `Uint8Array` not a valid type for a **bytea** field?"},"comment":{"url":"https://api.github.com/repos/brianc/node-postgres/issues/comments/260423628","html_url":"https://github.com/brianc/node-postgres/issues/1166#issuecomment-260423628","issue_url":"https://api.github.com/repos/brianc/node-postgres/issues/1166","id":260423628,"user":{"login":"rpedela","id":1952582,"avatar_url":"https://avatars.githubusercontent.com/u/1952582?v=3","gravatar_id":"","url":"https://api.github.com/users/rpedela","html_url":"https://github.com/rpedela","followers_url":"https://api.github.com/users/rpedela/followers","following_url":"https://api.github.com/users/rpedela/following{/other_user}","gists_url":"https://api.github.com/users/rpedela/gists{/gist_id}","starred_url":"https://api.github.com/users/rpedela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rpedela/subscriptions","organizations_url":"https://api.github.com/users/rpedela/orgs","repos_url":"https://api.github.com/users/rpedela/repos","events_url":"https://api.github.com/users/rpedela/events{/privacy}","received_events_url":"https://api.github.com/users/rpedela/received_events","type":"User","site_admin":false},"created_at":"2016-11-14T18:45:13Z","updated_at":"2016-11-14T18:45:13Z","body":"Can you provide a simple but complete example? Can you provide the full psql output for ```\\d DeviceOS```"}}
{"actor":{"display_login":"rpedela"}}