{"action":"closed","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/906","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/906/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/906/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/906/events","html_url":"https://github.com/tgriesser/knex/issues/906","id":96767161,"number":906,"title":"oracle id sequence trigger does not handle manual id inserts","user":{"login":"helios1138","id":7106681,"avatar_url":"https://avatars.githubusercontent.com/u/7106681?v=3","gravatar_id":"","url":"https://api.github.com/users/helios1138","html_url":"https://github.com/helios1138","followers_url":"https://api.github.com/users/helios1138/followers","following_url":"https://api.github.com/users/helios1138/following{/other_user}","gists_url":"https://api.github.com/users/helios1138/gists{/gist_id}","starred_url":"https://api.github.com/users/helios1138/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/helios1138/subscriptions","organizations_url":"https://api.github.com/users/helios1138/orgs","repos_url":"https://api.github.com/users/helios1138/repos","events_url":"https://api.github.com/users/helios1138/events{/privacy}","received_events_url":"https://api.github.com/users/helios1138/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2015-07-23T09:07:34Z","updated_at":"2016-09-12T07:52:14Z","closed_at":"2016-09-12T07:52:14Z","body":"Currently increment ids in oracle are working using trigger and a sequence, but if you manually insert a record with an ID, the sequence is not being updated. So if I insert, say, something with ID:4 into an empty table, next insert will be with ID:2, not ID:5. I think the trigger should be changed so that it also sets the lastId in sequence as max id from inserted records."}}
{"actor":{"display_login":"elhigu"}}