{"action":"created","issue":{"url":"https://api.github.com/repos/php-enqueue/enqueue-dev/issues/670","repository_url":"https://api.github.com/repos/php-enqueue/enqueue-dev","labels_url":"https://api.github.com/repos/php-enqueue/enqueue-dev/issues/670/labels{/name}","comments_url":"https://api.github.com/repos/php-enqueue/enqueue-dev/issues/670/comments","events_url":"https://api.github.com/repos/php-enqueue/enqueue-dev/issues/670/events","html_url":"https://github.com/php-enqueue/enqueue-dev/issues/670","id":387876982,"node_id":"MDU6SXNzdWUzODc4NzY5ODI=","number":670,"title":"[dbal] DBAL transport no longer works on PostgreSQL as of 0.9.0","user":{"login":"msheakoski","id":4156,"node_id":"MDQ6VXNlcjQxNTY=","avatar_url":"https://avatars0.githubusercontent.com/u/4156?v=4","gravatar_id":"","url":"https://api.github.com/users/msheakoski","html_url":"https://github.com/msheakoski","followers_url":"https://api.github.com/users/msheakoski/followers","following_url":"https://api.github.com/users/msheakoski/following{/other_user}","gists_url":"https://api.github.com/users/msheakoski/gists{/gist_id}","starred_url":"https://api.github.com/users/msheakoski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msheakoski/subscriptions","organizations_url":"https://api.github.com/users/msheakoski/orgs","repos_url":"https://api.github.com/users/msheakoski/repos","events_url":"https://api.github.com/users/msheakoski/events{/privacy}","received_events_url":"https://api.github.com/users/msheakoski/received_events","type":"User","site_admin":false},"labels":[{"id":1141574753,"node_id":"MDU6TGFiZWwxMTQxNTc0NzUz","url":"https://api.github.com/repos/php-enqueue/enqueue-dev/labels/0.9","name":"0.9","color":"e6e6e6","default":false},{"id":508691298,"node_id":"MDU6TGFiZWw1MDg2OTEyOTg=","url":"https://api.github.com/repos/php-enqueue/enqueue-dev/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2018-12-05T17:59:37Z","updated_at":"2018-12-18T08:40:53Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"There is an issue of PostgreSQL not being able to work with UUID byte sequences produced by ramsey/uuid (see ramsey/uuid#179 for more details). The UUID type in PostgreSQL only accepts UUIDs in the hex string format (see https://www.postgresql.org/docs/current/datatype-uuid.html).\r\n\r\nAdditionally, according to [this comment](https://github.com/ramsey/uuid/blob/fb2e2079c6b1ea57672814ccfa513e2584b8624a/src/Codec/OrderedTimeCodec.php#L20-L21), OrderedTimeCodec only works with UUIDv1 and [you are using UUIDv4](https://github.com/php-enqueue/enqueue-dev/blob/ce8414d6d4169f63a74783bc1d8d166dff34c6a8/pkg/dbal/DbalProducer.php#L74) which is random, so I do not think that the codec is actually doing anything useful here.\r\n\r\n**Temporary solution:**\r\nI made a [hotfix which switches binary back to hex string](https://github.com/msheakoski/dbal/commit/16581a8813b49a4108c64ffe2e4166380a865612) in case anybody needs to get PostgreSQL working while this issue is being examined."},"comment":{"url":"https://api.github.com/repos/php-enqueue/enqueue-dev/issues/comments/448140528","html_url":"https://github.com/php-enqueue/enqueue-dev/issues/670#issuecomment-448140528","issue_url":"https://api.github.com/repos/php-enqueue/enqueue-dev/issues/670","id":448140528,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0ODE0MDUyOA==","user":{"login":"jverdeyen","id":117409,"node_id":"MDQ6VXNlcjExNzQwOQ==","avatar_url":"https://avatars1.githubusercontent.com/u/117409?v=4","gravatar_id":"","url":"https://api.github.com/users/jverdeyen","html_url":"https://github.com/jverdeyen","followers_url":"https://api.github.com/users/jverdeyen/followers","following_url":"https://api.github.com/users/jverdeyen/following{/other_user}","gists_url":"https://api.github.com/users/jverdeyen/gists{/gist_id}","starred_url":"https://api.github.com/users/jverdeyen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jverdeyen/subscriptions","organizations_url":"https://api.github.com/users/jverdeyen/orgs","repos_url":"https://api.github.com/users/jverdeyen/repos","events_url":"https://api.github.com/users/jverdeyen/events{/privacy}","received_events_url":"https://api.github.com/users/jverdeyen/received_events","type":"User","site_admin":false},"created_at":"2018-12-18T08:40:53Z","updated_at":"2018-12-18T08:40:53Z","author_association":"CONTRIBUTOR","body":"> @jverdeyen yeap, it should be the way you've done it.\r\n\r\nOk, I'll clean it up and create a PR for this change."}}
{"actor":{"display_login":"jverdeyen"}}