Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

ошибка в b4_btree_pgstattuple.sql #21

Closed
sgrinko opened this issue May 16, 2018 · 0 comments · Fixed by #26
Closed

ошибка в b4_btree_pgstattuple.sql #21

sgrinko opened this issue May 16, 2018 · 0 comments · Fixed by #26
Assignees

Comments

@sgrinko
Copy link

sgrinko commented May 16, 2018

У меня много схем в БД и поэтому проявилась вот такая ошибка:

ERROR:  cross-database references are not implemented: "bankrupt_bulk.bankrupt_bulk.idx_address_changes"

это связано вот с этим:
schemaname || '.' || p.indexrelid::regclass::text
для объекта находящегося по пути поиска p.indexrelid::regclass::text схема отсутствует, а вот если объект находится вне пути поиска то схема добавляется и поэтому получается задвоение схемы.
Предлагаю вообще убрать schemaname || '.' || . Или же сделать более интеллектуальный анализ.

@NikolayS NikolayS self-assigned this Jun 12, 2018
NikolayS added a commit that referenced this issue Nov 26, 2018
Fix: b4 fails if there are multiple schemas, reported by @sgrinko #21
NikolayS added a commit that referenced this issue Nov 26, 2018
This really fixes the problem in report b4, when there are custom schemas in database
NikolayS added a commit that referenced this issue Feb 9, 2020
This really fixes the problem in report b4, when there are custom schemas in database
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants