{"action":"created","issue":{"url":"https://api.github.com/repos/keithf4/pg_partman/issues/124","repository_url":"https://api.github.com/repos/keithf4/pg_partman","labels_url":"https://api.github.com/repos/keithf4/pg_partman/issues/124/labels{/name}","comments_url":"https://api.github.com/repos/keithf4/pg_partman/issues/124/comments","events_url":"https://api.github.com/repos/keithf4/pg_partman/issues/124/events","html_url":"https://github.com/keithf4/pg_partman/issues/124","id":161295532,"number":124,"title":"ID partitionning: Create partition for 1 exact value","user":{"login":"thomasboussekey","id":14348412,"avatar_url":"https://avatars.githubusercontent.com/u/14348412?v=3","gravatar_id":"","url":"https://api.github.com/users/thomasboussekey","html_url":"https://github.com/thomasboussekey","followers_url":"https://api.github.com/users/thomasboussekey/followers","following_url":"https://api.github.com/users/thomasboussekey/following{/other_user}","gists_url":"https://api.github.com/users/thomasboussekey/gists{/gist_id}","starred_url":"https://api.github.com/users/thomasboussekey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thomasboussekey/subscriptions","organizations_url":"https://api.github.com/users/thomasboussekey/orgs","repos_url":"https://api.github.com/users/thomasboussekey/repos","events_url":"https://api.github.com/users/thomasboussekey/events{/privacy}","received_events_url":"https://api.github.com/users/thomasboussekey/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/keithf4/pg_partman/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-06-20T21:08:36Z","updated_at":"2016-06-23T11:37:25Z","closed_at":null,"body":"Hello,\r\n\r\nI try to create an `ID partitionning` with one partition per integer.\r\nWe use a _human readable_ identifier, that is 12 digits long, and we want to create 1 partition per **exact value** of this identifier.\r\n\r\nLooking into the code of the extension, I see that the lower value for parameter `p_interval` in the function `create_parent` is 10. So our **ids** are floored to the nearest tenth.\r\n\r\nHave you already tried to change the `p_interval` minimal value to 1?\r\n\r\nThanks in advance for your help,\r\nRegards,\r\nThomas"},"comment":{"url":"https://api.github.com/repos/keithf4/pg_partman/issues/comments/228023674","html_url":"https://github.com/keithf4/pg_partman/issues/124#issuecomment-228023674","issue_url":"https://api.github.com/repos/keithf4/pg_partman/issues/124","id":228023674,"user":{"login":"thomasboussekey","id":14348412,"avatar_url":"https://avatars.githubusercontent.com/u/14348412?v=3","gravatar_id":"","url":"https://api.github.com/users/thomasboussekey","html_url":"https://github.com/thomasboussekey","followers_url":"https://api.github.com/users/thomasboussekey/followers","following_url":"https://api.github.com/users/thomasboussekey/following{/other_user}","gists_url":"https://api.github.com/users/thomasboussekey/gists{/gist_id}","starred_url":"https://api.github.com/users/thomasboussekey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thomasboussekey/subscriptions","organizations_url":"https://api.github.com/users/thomasboussekey/orgs","repos_url":"https://api.github.com/users/thomasboussekey/repos","events_url":"https://api.github.com/users/thomasboussekey/events{/privacy}","received_events_url":"https://api.github.com/users/thomasboussekey/received_events","type":"User","site_admin":false},"created_at":"2016-06-23T11:37:25Z","updated_at":"2016-06-23T11:37:25Z","body":"Hello Keith,\r\n\r\nThanks for your feedback.\r\n\r\nThanks for the information about `range_patitioning`, I didn't know this extension.\r\n\r\nTo be able to use your extension, we have modified our `ID` field, adding a final **0** digit, in order to align the partition name with the `ID` value, to ease support on the schema.\r\n\r\nAre you interested in adding a new functionnality on `pg_partman` to manage single ID partitioning?\r\nIf yes, I'm interested in contributing.\r\n\r\nHave a nice day,\r\nThomas"}}
{"actor":{"display_login":"thomasboussekey"}}