{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/23584","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/23584/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/23584/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/23584/events","html_url":"https://github.com/cockroachdb/cockroach/issues/23584","id":303444123,"number":23584,"title":"sql: cannot run TRUNCATE on system.locations","user":{"login":"knz","id":642886,"avatar_url":"https://avatars3.githubusercontent.com/u/642886?v=4","gravatar_id":"","url":"https://api.github.com/users/knz","html_url":"https://github.com/knz","followers_url":"https://api.github.com/users/knz/followers","following_url":"https://api.github.com/users/knz/following{/other_user}","gists_url":"https://api.github.com/users/knz/gists{/gist_id}","starred_url":"https://api.github.com/users/knz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/knz/subscriptions","organizations_url":"https://api.github.com/users/knz/orgs","repos_url":"https://api.github.com/users/knz/repos","events_url":"https://api.github.com/users/knz/events{/privacy}","received_events_url":"https://api.github.com/users/knz/received_events","type":"User","site_admin":false},"labels":[{"id":514075047,"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/community-questions","name":"community-questions","color":"bfd4f2","default":false}],"state":"open","locked":false,"assignee":{"login":"vivekmenezes","id":11774212,"avatar_url":"https://avatars1.githubusercontent.com/u/11774212?v=4","gravatar_id":"","url":"https://api.github.com/users/vivekmenezes","html_url":"https://github.com/vivekmenezes","followers_url":"https://api.github.com/users/vivekmenezes/followers","following_url":"https://api.github.com/users/vivekmenezes/following{/other_user}","gists_url":"https://api.github.com/users/vivekmenezes/gists{/gist_id}","starred_url":"https://api.github.com/users/vivekmenezes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vivekmenezes/subscriptions","organizations_url":"https://api.github.com/users/vivekmenezes/orgs","repos_url":"https://api.github.com/users/vivekmenezes/repos","events_url":"https://api.github.com/users/vivekmenezes/events{/privacy}","received_events_url":"https://api.github.com/users/vivekmenezes/received_events","type":"User","site_admin":false},"assignees":[{"login":"vivekmenezes","id":11774212,"avatar_url":"https://avatars1.githubusercontent.com/u/11774212?v=4","gravatar_id":"","url":"https://api.github.com/users/vivekmenezes","html_url":"https://github.com/vivekmenezes","followers_url":"https://api.github.com/users/vivekmenezes/followers","following_url":"https://api.github.com/users/vivekmenezes/following{/other_user}","gists_url":"https://api.github.com/users/vivekmenezes/gists{/gist_id}","starred_url":"https://api.github.com/users/vivekmenezes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vivekmenezes/subscriptions","organizations_url":"https://api.github.com/users/vivekmenezes/orgs","repos_url":"https://api.github.com/users/vivekmenezes/repos","events_url":"https://api.github.com/users/vivekmenezes/events{/privacy}","received_events_url":"https://api.github.com/users/vivekmenezes/received_events","type":"User","site_admin":false}],"milestone":null,"comments":12,"created_at":"2018-03-08T11:15:58Z","updated_at":"2018-03-08T13:43:45Z","closed_at":null,"author_association":"OWNER","body":"From Gitter:\r\n\r\n> (10:38) < 0xbaadf00d> I can add location on system.locations, but can't truncate the table\r\n> (10:39) < 0xbaadf00d> \r\n> ```\r\n> root@:26257/system> TRUNCATE locations;\r\n> pq: user root does not have DROP privilege on relation locations\r\n> ```\r\n\r\n(To provide some context for anyone coming to this discussion without that technical background: DROP on a system table is a no-no because the value of the table ID is important)\r\n\r\n@vivekmenezes can you triage this"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/371490009","html_url":"https://github.com/cockroachdb/cockroach/issues/23584#issuecomment-371490009","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/23584","id":371490009,"user":{"login":"knz","id":642886,"avatar_url":"https://avatars3.githubusercontent.com/u/642886?v=4","gravatar_id":"","url":"https://api.github.com/users/knz","html_url":"https://github.com/knz","followers_url":"https://api.github.com/users/knz/followers","following_url":"https://api.github.com/users/knz/following{/other_user}","gists_url":"https://api.github.com/users/knz/gists{/gist_id}","starred_url":"https://api.github.com/users/knz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/knz/subscriptions","organizations_url":"https://api.github.com/users/knz/orgs","repos_url":"https://api.github.com/users/knz/repos","events_url":"https://api.github.com/users/knz/events{/privacy}","received_events_url":"https://api.github.com/users/knz/received_events","type":"User","site_admin":false},"created_at":"2018-03-08T13:43:45Z","updated_at":"2018-03-08T13:43:45Z","author_association":"OWNER","body":"would work for me, but then we need a proper user story for `system.locations`."}}
{"actor":{"display_login":"knz"}}