{"action":"opened","issue":{"url":"https://api.github.com/repos/doctrine/dbal/issues/3139","repository_url":"https://api.github.com/repos/doctrine/dbal","labels_url":"https://api.github.com/repos/doctrine/dbal/issues/3139/labels{/name}","comments_url":"https://api.github.com/repos/doctrine/dbal/issues/3139/comments","events_url":"https://api.github.com/repos/doctrine/dbal/issues/3139/events","html_url":"https://github.com/doctrine/dbal/issues/3139","id":322216537,"number":3139,"title":"PostgreSQL 10: sequence definition failed","user":{"login":"TomasPilar","id":8326937,"avatar_url":"https://avatars1.githubusercontent.com/u/8326937?v=4","gravatar_id":"","url":"https://api.github.com/users/TomasPilar","html_url":"https://github.com/TomasPilar","followers_url":"https://api.github.com/users/TomasPilar/followers","following_url":"https://api.github.com/users/TomasPilar/following{/other_user}","gists_url":"https://api.github.com/users/TomasPilar/gists{/gist_id}","starred_url":"https://api.github.com/users/TomasPilar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TomasPilar/subscriptions","organizations_url":"https://api.github.com/users/TomasPilar/orgs","repos_url":"https://api.github.com/users/TomasPilar/repos","events_url":"https://api.github.com/users/TomasPilar/events{/privacy}","received_events_url":"https://api.github.com/users/TomasPilar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-11T08:44:37Z","updated_at":"2018-05-11T08:44:37Z","closed_at":null,"author_association":"NONE","body":"### Bug Report\r\n\r\n|    Q        |   A\r\n|------------ | ------\r\n| BC Break    | no\r\n| Version     | 2.7.1\r\n\r\n#### Summary\r\n\r\nCommad `orm:schema-tool:update` run invalid SQL`SELECT min_value, increment_by FROM XXX` after upgrade from PostgreSQL 9.6 to 10.3. \r\n\r\n#### Current behavior\r\n\r\nThere is invalid SQL query for PostgreSQL 10+ at [PostgreSqlSchemaManager.php](https://github.com/doctrine/dbal/blob/master/lib/Doctrine/DBAL/Schema/PostgreSqlSchemaManager.php#L310) . In PostgreSQL 10+ is new table for sequences called \"pg_sequences\" which contains required informations. \r\n\r\n#### How to reproduce\r\n\r\nInstall PostgreSQL 10+ and run command `orm:schema-tool:update` or simply call method `\\Doctrine\\DBAL\\Schema\\PostgreSqlSchemaManager::_getPortableSequenceDefinition()` with some sequence name.\r\n\r\n#### Expected behavior\r\n`PostgreSQLSchemaManager` should call different SQL query for PostgreSQL 10+.\r\n\r\nWorking solution is written here https://stackoverflow.com/a/47980943. \r\n"}}
{"actor":{"display_login":"TomasPilar"}}