Skip to content

After renaming parent table getting error "naming sequence <new_parent_table_name_seq> does not exist" #127

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

Closed
andrii-panfilov-rf opened this issue Oct 4, 2017 · 3 comments
Assignees
Labels
Milestone

Comments

@andrii-panfilov-rf
Copy link

andrii-panfilov-rf commented Oct 4, 2017

Hi,
This is happened during auto creation of new range partition.
This issue is caused by using new name of the sequence. So if parent table renamed then naming sequence should be renamed as well.
It is possible to fix this manualy with ALTER SEQUENCE <old_parent_table_name_seq> RENAME TO <new_parent_table_name_seq>;

Thank you.

@andrii-panfilov-rf andrii-panfilov-rf changed the title Bug : After renaming parent table getting error "naming sequence <new_parent_table_name_seq> does not exist" After renaming parent table getting error "naming sequence <new_parent_table_name_seq> does not exist" Oct 4, 2017
@funbringer funbringer self-assigned this Oct 4, 2017
@funbringer funbringer added the bug label Oct 4, 2017
@funbringer
Copy link
Collaborator

Hi @andrii-panfilov-rf,

Many thanks for the bug report! We'll fix this in the upcoming release.

@andrii-panfilov-rf
Copy link
Author

Thank you for a such great extension )

@funbringer funbringer modified the milestones: Release 1.5, Release 1.4.7 Oct 4, 2017
@funbringer
Copy link
Collaborator

Fixed, release 1.4.7 is out.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants