{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/86","labels_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/86/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/86/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/86/events","html_url":"https://github.com/CartoDB/cartodb-postgresql/issues/86","id":89284340,"number":86,"title":"Long table names causing trouble","user":{"login":"rafatower","id":1914276,"avatar_url":"https://avatars.githubusercontent.com/u/1914276?v=3","gravatar_id":"","url":"https://api.github.com/users/rafatower","html_url":"https://github.com/rafatower","followers_url":"https://api.github.com/users/rafatower/followers","following_url":"https://api.github.com/users/rafatower/following{/other_user}","gists_url":"https://api.github.com/users/rafatower/gists{/gist_id}","starred_url":"https://api.github.com/users/rafatower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rafatower/subscriptions","organizations_url":"https://api.github.com/users/rafatower/orgs","repos_url":"https://api.github.com/users/rafatower/repos","events_url":"https://api.github.com/users/rafatower/events{/privacy}","received_events_url":"https://api.github.com/users/rafatower/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-06-18T12:45:43Z","updated_at":"2015-06-23T16:14:23Z","closed_at":null,"body":"See https://github.com/CartoDB/cartodb/issues/3808\r\n\r\nThe problem is the 63 char limit for identifiers.\r\n- `CDB_QueryTables` returns `name[]`, containing `\"schema.table\"`'s that can exceed 63 chars in total\r\n- When trying to join that with `CDB_TablesMetadata`, `name`'s potentially do not fit in a `regclass`\r\n\r\nWe should probably modify `CDB_QueryTables` to return `(schema, table)` pairs"},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/comments/114560234","html_url":"https://github.com/CartoDB/cartodb-postgresql/issues/86#issuecomment-114560234","issue_url":"https://api.github.com/repos/CartoDB/cartodb-postgresql/issues/86","id":114560234,"user":{"login":"rafatower","id":1914276,"avatar_url":"https://avatars.githubusercontent.com/u/1914276?v=3","gravatar_id":"","url":"https://api.github.com/users/rafatower","html_url":"https://github.com/rafatower","followers_url":"https://api.github.com/users/rafatower/followers","following_url":"https://api.github.com/users/rafatower/following{/other_user}","gists_url":"https://api.github.com/users/rafatower/gists{/gist_id}","starred_url":"https://api.github.com/users/rafatower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rafatower/subscriptions","organizations_url":"https://api.github.com/users/rafatower/orgs","repos_url":"https://api.github.com/users/rafatower/repos","events_url":"https://api.github.com/users/rafatower/events{/privacy}","received_events_url":"https://api.github.com/users/rafatower/received_events","type":"User","site_admin":false},"created_at":"2015-06-23T16:14:23Z","updated_at":"2015-06-23T16:14:23Z","body":"@javisantana @rochoa @pramsey looking forward to hear your opinion on my comment right above.\r\n\r\nMy vote for option 2."}}