{"action":"closed","issue":{"url":"https://api.github.com/repos/NikolayS/postgres_dba/issues/21","repository_url":"https://api.github.com/repos/NikolayS/postgres_dba","labels_url":"https://api.github.com/repos/NikolayS/postgres_dba/issues/21/labels{/name}","comments_url":"https://api.github.com/repos/NikolayS/postgres_dba/issues/21/comments","events_url":"https://api.github.com/repos/NikolayS/postgres_dba/issues/21/events","html_url":"https://github.com/NikolayS/postgres_dba/issues/21","id":323506455,"node_id":"MDU6SXNzdWUzMjM1MDY0NTU=","number":21,"title":"ошибка в b4_btree_pgstattuple.sql","user":{"login":"sgrinko","id":10084993,"node_id":"MDQ6VXNlcjEwMDg0OTkz","avatar_url":"https://avatars2.githubusercontent.com/u/10084993?v=4","gravatar_id":"","url":"https://api.github.com/users/sgrinko","html_url":"https://github.com/sgrinko","followers_url":"https://api.github.com/users/sgrinko/followers","following_url":"https://api.github.com/users/sgrinko/following{/other_user}","gists_url":"https://api.github.com/users/sgrinko/gists{/gist_id}","starred_url":"https://api.github.com/users/sgrinko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgrinko/subscriptions","organizations_url":"https://api.github.com/users/sgrinko/orgs","repos_url":"https://api.github.com/users/sgrinko/repos","events_url":"https://api.github.com/users/sgrinko/events{/privacy}","received_events_url":"https://api.github.com/users/sgrinko/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"NikolayS","id":1345402,"node_id":"MDQ6VXNlcjEzNDU0MDI=","avatar_url":"https://avatars3.githubusercontent.com/u/1345402?v=4","gravatar_id":"","url":"https://api.github.com/users/NikolayS","html_url":"https://github.com/NikolayS","followers_url":"https://api.github.com/users/NikolayS/followers","following_url":"https://api.github.com/users/NikolayS/following{/other_user}","gists_url":"https://api.github.com/users/NikolayS/gists{/gist_id}","starred_url":"https://api.github.com/users/NikolayS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NikolayS/subscriptions","organizations_url":"https://api.github.com/users/NikolayS/orgs","repos_url":"https://api.github.com/users/NikolayS/repos","events_url":"https://api.github.com/users/NikolayS/events{/privacy}","received_events_url":"https://api.github.com/users/NikolayS/received_events","type":"User","site_admin":false},"assignees":[{"login":"NikolayS","id":1345402,"node_id":"MDQ6VXNlcjEzNDU0MDI=","avatar_url":"https://avatars3.githubusercontent.com/u/1345402?v=4","gravatar_id":"","url":"https://api.github.com/users/NikolayS","html_url":"https://github.com/NikolayS","followers_url":"https://api.github.com/users/NikolayS/followers","following_url":"https://api.github.com/users/NikolayS/following{/other_user}","gists_url":"https://api.github.com/users/NikolayS/gists{/gist_id}","starred_url":"https://api.github.com/users/NikolayS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NikolayS/subscriptions","organizations_url":"https://api.github.com/users/NikolayS/orgs","repos_url":"https://api.github.com/users/NikolayS/repos","events_url":"https://api.github.com/users/NikolayS/events{/privacy}","received_events_url":"https://api.github.com/users/NikolayS/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-05-16T07:52:04Z","updated_at":"2018-11-26T21:55:23Z","closed_at":"2018-11-26T21:55:23Z","author_association":"NONE","body":"У меня много схем в БД и поэтому проявилась вот такая ошибка:\r\n```\r\nERROR:  cross-database references are not implemented: \"bankrupt_bulk.bankrupt_bulk.idx_address_changes\"\r\n```\r\nэто связано вот с этим:\r\n`schemaname || '.' || p.indexrelid::regclass::text`\r\nдля объекта находящегося по пути поиска `p.indexrelid::regclass::text` схема отсутствует, а вот если объект находится вне пути поиска то схема добавляется и поэтому получается задвоение схемы.\r\nПредлагаю вообще убрать `schemaname || '.' || ` . Или же сделать более интеллектуальный анализ."}}
{"actor":{"display_login":"NikolayS"}}