-
Notifications
You must be signed in to change notification settings - Fork 4.1k
Rewrite sequence expressions in views #61205
Copy link
Copy link
Closed
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Description
Describe the problem
After #59864, we're now rewriting DEFAULT expressions to reference sequences via their IDs. This results in the ability for sequences used in default expressions to be renamed. However, we don't perform this rewrite for views that reference sequences. As a result, we still cannot rename sequences used in views.
To Reproduce
CREATE SEQUENCE s;
CREATE VIEW v AS SELECT nextval('s');
ALTER SEQUENCE s RENAME TO s2; // ERROR: cannot rename relation "s" because view "v" depends on it
Expected behavior
We should rewrite sequence expressions in views to also reference sequences by ID. This will allow us to rename sequences that are used in views.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.