Skip to content

Do not ignore schema of a table #983

New issue

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

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

Already on GitHub? Sign in to your account

Open
Denchick opened this issue Jan 29, 2025 · 0 comments
Open

Do not ignore schema of a table #983

Denchick opened this issue Jan 29, 2025 · 0 comments
Labels
bug Something isn't working good first issue Good for newcomers

Comments

@Denchick
Copy link
Collaborator

When you are adding a new table, you can specify a schema. For example:

ALTER DISTRIBUTION ds1 ATTACH RELATION schema_name.table_name DISTRIBUTION KEY id;

In fact, during query/transaction routing, the schema is not taken into account. If there are tables with the same name but different schemas, they will be incorrectly routed. To fix this bug, you have to remember about search_path as well.

@Denchick Denchick added bug Something isn't working good first issue Good for newcomers labels Jan 29, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

1 participant