{"action":"created","issue":{"url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1357","labels_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1357/labels{/name}","comments_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1357/comments","events_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1357/events","html_url":"https://github.com/puppetlabs/puppetdb/pull/1357","id":69036969,"number":1357,"title":"(PDB-1416) Change the postgres type for hashes and uuids","user":{"login":"ajroetker","id":3198124,"avatar_url":"https://avatars.githubusercontent.com/u/3198124?v=3","gravatar_id":"","url":"https://api.github.com/users/ajroetker","html_url":"https://github.com/ajroetker","followers_url":"https://api.github.com/users/ajroetker/followers","following_url":"https://api.github.com/users/ajroetker/following{/other_user}","gists_url":"https://api.github.com/users/ajroetker/gists{/gist_id}","starred_url":"https://api.github.com/users/ajroetker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajroetker/subscriptions","organizations_url":"https://api.github.com/users/ajroetker/orgs","repos_url":"https://api.github.com/users/ajroetker/repos","events_url":"https://api.github.com/users/ajroetker/events{/privacy}","received_events_url":"https://api.github.com/users/ajroetker/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-04-17T00:32:51Z","updated_at":"2015-04-17T16:25:47Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/puppetlabs/puppetdb/pulls/1357","html_url":"https://github.com/puppetlabs/puppetdb/pull/1357","diff_url":"https://github.com/puppetlabs/puppetdb/pull/1357.diff","patch_url":"https://github.com/puppetlabs/puppetdb/pull/1357.patch"},"body":"UUIDs stored as strings are about 36 bytes, and are 16 bytes stored as\r\nthe native type. Hashes are 40 bytes as characters, but only 20 has a\r\nbytea field.\r\nThis commit changes PuppetDB to store the uuid's as their native type\r\nand hashes as the bytea type (we can easily interact with the bytea type\r\nby using the hexidecimal shorthand, prefixing hashes with '\\x'.\r\nThis commit also enforces that our uuids be non-nil as all supported\r\nversions of puppet enforce this."},"comment":{"url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/comments/94020997","html_url":"https://github.com/puppetlabs/puppetdb/pull/1357#issuecomment-94020997","issue_url":"https://api.github.com/repos/puppetlabs/puppetdb/issues/1357","id":94020997,"user":{"login":"pljenkinsro","id":6546951,"avatar_url":"https://avatars.githubusercontent.com/u/6546951?v=3","gravatar_id":"","url":"https://api.github.com/users/pljenkinsro","html_url":"https://github.com/pljenkinsro","followers_url":"https://api.github.com/users/pljenkinsro/followers","following_url":"https://api.github.com/users/pljenkinsro/following{/other_user}","gists_url":"https://api.github.com/users/pljenkinsro/gists{/gist_id}","starred_url":"https://api.github.com/users/pljenkinsro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pljenkinsro/subscriptions","organizations_url":"https://api.github.com/users/pljenkinsro/orgs","repos_url":"https://api.github.com/users/pljenkinsro/repos","events_url":"https://api.github.com/users/pljenkinsro/events{/privacy}","received_events_url":"https://api.github.com/users/pljenkinsro/received_events","type":"User","site_admin":false},"created_at":"2015-04-17T16:25:47Z","updated_at":"2015-04-17T16:25:47Z","body":"Test FAILed.\nRefer to this link for build results (access rights to CI server needed): \nhttps://jenkins.puppetlabs.com/job/platform_puppetdb_intn-sys_pr/1047/"}}